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 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(
)
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!
Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com
