Number interpretation variables are system defined, that is, they are automatically
generated according to the current regional settings of the operating system when a new
document is created. In QlikView Desktop, this is according to the settings of the computer operating system, and in QlikView, it is according to the operating system of the server where QlikView is installed.
The variables are included
at the top of the script of the new QlikView document and substitute
operating system defaults for certain number formatting settings at the
time of the script execution. They can be deleted, edited or duplicated
freely.
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.
Currency formatting
The decimal separator defined replaces the decimal symbol for currency
of the operating
system (regional
settings).
The setting defines which day in January to set as reference day to define week 1. By default, QlikView functions use 4 as the reference day. This means that week 1 must contain January 4, or put differently, that week 1 must always have at least 4 days in January.
The following values can be used to set a different reference day:
The setting defines which month to use as first month of the year, which can be used to define financial years that use a monthly offset, for example starting April 1.