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
app is created. In Qlik Sense Desktop, this is according to the settings of the computer operating system, and in Qlik Sense, it is according to the operating system of the server where Qlik Sense is installed.
The variables are included
at the top of the script of the new Qlik Sense app 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.
Tip noteIf you want to create an app for a certain locale, the easiest way is probably to use Qlik Sense Desktop on a computer with the desired locale setting in the operating system to create the app. The app will then contain the appropriate regional settings of that locale, and you can move it to a Qlik Sense server of choice for further development.
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 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).
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!
