The interpretation functions evaluate the contents of input text fields or expressions, and impose a specified data format on the resulting numeric value. With these functions, you can specify the format of the number, in accordance with its data type, including attributes such as: decimal separator,
thousands separator,and date format.
The interpretation functions all return a dual value with both the string and the number value, but can be thought of as performing a string-to-number conversion. The functions take the text value of the input expression and generate a number representing the string.
In contrast, the formatting functions do the opposite: they take numeric expressions and evaluate them as strings, specifying the display format of the resulting text.
If no interpretation functions are used, QlikView 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.
All interpretation functions can be used in both load scripts and chart expressions.
Information noteFor reasons of clarity, all number representations are given with a decimal point as the 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.
Date# converts a text string to a numerical date by applying the provided date format pattern, or if omitted by the default date format pattern.
If the format code is omitted, the default date format set in the operating
system is used.
Interval#() evaluates
a text expression as a time interval
in the format set in the operating system, by default, or in the format specified in the second argument, if supplied.
Money#() converts a text string to a money value, in the format set in the load script or the operating system, unless a format string is supplied. Custom decimal and thousand separator symbols are optional parameters.
Num#() interprets a text string as a numerical value, that is it converts the input string to a number using the format specified in the second parameter. If the second parameter is omitted, it uses the decimal and thousand separators set in the data load script. Custom decimal and thousand separator symbols are optional parameters.
Time#() evaluates
an expression as a time value, in the time format set in the load script or the operating system, unless a format string is supplied..
Timestamp#() evaluates
an expression as a date and
time value, in the timestamp format set in the load script or the operating system, unless a format string is supplied.
Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com
