QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Number interpretation variables

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

Number formatting

Time formatting

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?