Qlik Sense contains several hundred ready-made functions that can be used in charts when creating visualizations. Functions can be, for example, mathematical, logical, can operate on financial or date and time information, can be used to manipulate strings, and other situations.
Functions can be grouped into the types:
- Aggregation functions, which use several records as input and produce a single value result.
- Scalar functions, which take a single input and produce a single output.
- Range functions, which produce a single value based on a range of input values.
-
Range-producing functions, which are like range functions, but produce a range of values as output.
Many of the functions can be used in both chart expressions and scripts, but some are specific for chart expressions.
Information noteA few differences exist between script expressions and chart expressions in terms of syntax and available functions. The most important difference is the role of the aggregation functions and the use of field references. The basic rule is that any field name in a chart expression must be enclosed by exactly one aggregation function. An aggregation function can never have another expression containing an aggregation function as argument.