Skip to main content Skip to complementary content

Inter-record functions

Inter-record functions are used:

  • In the load script, when a value from previously loaded records of data is needed for the evaluation of the current record.
  • In a chart expression, when another value from the data set of a chart is needed.
Information note

Sorting on y-values in charts or sorting by expression columns in tables is not allowed when an inter-record chart function is used in any of the chart's expressions. These sort alternatives are therefore automatically disabled. When you use an inter-record chart function in a visualization or table, the sorting of the visualization will revert back to the sorted input to the inter-record function. This limitation does not apply to the equivalent script function, if there is one.

Information noteFrom QlikView 12.00, suppression of zero values is activated by default. If you want to retain the same behavior as in QlikView 11.20 when using inter-record functions, you should disable the suppression of zero values. Open Chart Properties, go to the Presentation tab, and deselect Suppress Zero-Values.
Information noteSelf-referencing expression definitions can only reliably be made in tables with fewer than 100 rows, but this may vary depending on the hardware that the Qlik engine is running on.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

Row functions

These functions can only be used in chart expressions.

Column functions

These functions can only be used in chart expressions.

Field functions

Pivot table functions

These functions can only be used in chart expressions.

Inter-record functions in the load script

Learn more


Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: