In the data 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 visualization is needed.
Information noteSorting on y-values in charts or sorting by expression columns in straight tables is not allowed when chart inter-record functions are
used in any of the chart's expressions. These sort alternatives are therefore
automatically disabled.
Suppression of zero values is automatically disabled when these functions are used.
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.
Above() evaluates an expression at a row above the current row within a column segment in a table. The row for which it is calculated depends on the value of offset, if present, the default being the row directly above. For charts other than tables, Above() evaluates for the row above the current row in the chart's straight table equivalent.
Below() evaluates an expression at a row below the current row within a column segment in a table. The row for which it is calculated depends on the value of offset, if present, the default being the row directly below. For charts other than tables, Below() evaluates for the row below the current column in the chart's straight table equivalent.
Bottom() evaluates an expression at the last (bottom) row of a column segment in a table. The row for which it is calculated depends on the value of offset, if present, the default being the bottom row. For
charts other than tables, the evaluation is made on the last row of the current column in the chart's straight table equivalent.
Top() evaluates an expression at the first (top) row of a column segment in a table. The row for which it is calculated depends on the value of offset, if present, the default being the top row. For charts other than tables, theTop() evaluation is made on the first row of the current column in the chart's straight table equivalent.
NoOfRows() returns the number of rows in the current column segment in a table. For bitmap charts, NoOfRows() returns the number of rows in the chart's straight table equivalent.
RowNo() returns the number of the current row within the current column segment
in a table. For bitmap charts, RowNo() returns the number of the current row within the chart's straight table equivalent.
These functions can only be used in chart expressions.
Column() returns the value found in the column corresponding to ColumnNo in a straight table, disregarding dimensions. For example Column(2) returns the value of the second measure column.
This script function determines whether a specific field
value exists in a specified field of the data loaded so far. Field
is a name or a string expression evaluating to a field name.
This script function returns the contents of the fieldname
in the record specified by row
in the internal table tablename.
Data are fetched from the associative Qlik Sense database.
This script function returns the value of expression
using data from the previous input record that was not discarded due to
a where clause. In the first record
of an internal table the function will return NULL.