Skip to main content

Range functions

The range functions are functions that take an array of values and produce a single value as a result. All range functions can be used in both the load script and in chart expressions.

For example, in a chart, a range function can calculate a single value from an inter-record array. In the load script, a range function can calculate a single value from an array of values in an internal table.

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.

Information noteRange functions supersede the following general numeric functions: numsum, numavg, numcount, nummin and nummax. These can still be used, but are not recommended.

Basic range functions

Counter range functions

Statistical range functions

Financial range functions

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: ampquestions@qlik.com