The interpretation functions interpret the contents of fields or expressions.
With these functions it is possible to state the data type, decimal separator,
thousands separator etc. used. All functions can be used in both data load scripts and chart expressions.
If no interpretation functions are used, Qlik Sense interprets the data
as a mix of numbers, dates, times, time stamps and strings, using the
default settings for number format, date format and time format defined
by script variables and by the operating system.
Information noteFor reasons of clarity, all number representations are given with
decimal point as decimal separator.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
This function evaluates
the expression as a date according
to the string given as format-code.
If the format code is omitted, the default date format set in the operating
system is used.
This function evaluates
the expression as a time interval
according to the string given as a format-code. If the format
code is omitted, the time format set in the operating system is
used.
This function evaluates
the expression numerically according
to the string given as format-code.
Decimal separator and thousands separator can be set as third and fourth
parameters. If the parameters 2-4 are omitted, the default number format
set by script variables or in the operating system is used.
This function evaluates
the expression numerically according to the string given as format-code.
Decimal separator and thousands separator can be set as third and fourth
parameters. If the parameters 2-4 are omitted, the default number format
set by script variables or in the operating system is used.
The time# function evaluates
the expression as time according
to the string given as format-code.
If the format code is omitted, the default time format set in the operating
system is used.
The timestamp# function evaluates
the expression as a date and
time according to the string given as format-code. If the format
code is omitted, the default date and time formats set in the operating
system are used.
