Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products. All content is subject to change and is provided without warranty.
This section describes functions for mathematical constants and Boolean values. These functions do not have any parameters, but the parentheses are still
required.
All functions can be used in both the data load script and in chart expressions.
The function returns the base of the natural logarithms, e (
2.71828...).
e( )
The function returns a dual value with text value 'False'
and numeric value 0, which can be used as logical false in expressions.
false(
)
The function returns the value of π (3.14159...).
pi(
)
The function returns a random number between 0 and 1. This can be used to create sample data.
rand(
)
Example:
This example script creates a table of 1000 records with randomly selected upper case characters, that is, characters in the range 65 to 91 (65+26).
Load
Chr( Floor(rand() * 26) + 65) as UCaseChar,
RecNo() as ID
Autogenerate 1000;
The function returns a dual value with text value 'True'
and numeric value -1, which can be used as logical true in expressions.
true(
)
Load script
The load script is a sequence of statements that defines what data to load and how to link the different loaded tables. It can be generated with the Data manager, or with the Data load editor, where it also can be viewed and edited.
