Counter functions

This script function returns a unique integer value for each distinct evaluated value of expression encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

autonumber(expression[ , AutoID])

This script function calculates a 128-bit hash of the combined input expression values and the returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used for example for creating a compact memory representation of a complex key.

autonumberhash128(expression {, expression})

This script function calculates a 256-bit hash of the combined input expression values and returns a unique integer value for each distinct hash value encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.

autonumberhash256(expression {, expression})

This script function returns the number of distinct values in a field. fieldname must be given as a string (for example a quoted literal).

fieldvaluecount(fieldname)

This script function returns an integer indicating the current iteration within a while clause. The first iteration has number 1. The IterNo function is only meaningful if used together with a while clause.

IterNo( )

This script functions returns an integer for the number of the currently read row of the current table. The first record is number 1.

RecNo( )

This function returns an integer for the position of the current row in the resulting QlikView internal table. The first row is number 1.

RowNo( )

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.

rowno([TOTAL])