A function is a type of procedure or routine that performs a specific task on data in documents. QlikView 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 script editor and in charts. Some functions are specific to charts (chart functions), and others are specific to the script 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.
