QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

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 data load script and in chart expressions.

For example, in a visualization, a range function can calculate a single value from an inter-record array. In the data 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.

Note: Range functions replace the following general numeric functions: numsum, numavg, numcount, nummin and nummax, which should now be regarded as obsolete.

Basic range functions

Counter range functions

Statistical range functions

Financial range functions

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?