Number interpretation variables are system defined. The variables are included
at the top of the load script and apply number formatting settings at the
time of the script execution. They can be deleted, edited, or duplicated.
Number interpretation variables are automatically
generated according to the current regional settings of the operating system when a new
app is created. In Qlik Sense Desktop, this is according to the settings of the computer operating system. In Qlik Sense, it is according to the operating system of the server where Qlik Sense is installed. If the Qlik Sense server you are accessing is set to Sweden, the Data load editor will use Swedish regional settings for dates, time, and currency. These regional format settings are not related to the language displayed in the Qlik Sense user interface. Qlik Sense will be displayed in the same language as the browser you are using.
Currency formatting
The decimal separator defined replaces the decimal symbol for currency set by your regional settings.
The numerical abbreviation sets which abbreviation to use for scale prefixes of numerals, for example M for mega or a million (106), and µ for micro (10-6).
This environment variable defines the date format used as the default in the app. The format is used both to interpret and format dates. If the variable is not defined, the date format of the regional settings of the operating system will be fetched when the script runs.
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.
Information noteThis setting is currently unused but reserved for future use.
Valid settings are 1 (January) to 12 (December). Default setting is 1.
Syntax:
FirstMonthOfYear
Example:
Set FirstMonthOfYear=4; //Sets the year to start in April
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!