A function is a type of procedure or routine that performs a specific task on data in apps. Qlik Sense provides several hundred functions that can be used for various purposes, such as: to perform calculations, interpret data or system information, determine conditions, and so on.
Many functions can be used both in the data load editor and in visualizations. Some functions are specific to visualizations (chart functions), and others are specific to the data load editor (script functions).
Functions are often, but not always, used in expressions.
The following list shows some examples of functions:
-
Max: an aggregation function that can be used in scripts and charts.
For example: Max(Sales) calculates the highest value in the field Sales.
-
IF: a conditional function that can be used in scripts and charts.
For example: IF(Amount>0, 'OK','Alarm') determines if the condition 'is the value of Amount greater than zero?' is met. If it is, OK is written, otherwise Alarm is written.
-
Date#: an interpretation function that can be used in scripts and charts.
For example: Date#(A) takes the input value A and evaluates it as a date.