Mastering Qlik Sense

Formatting settings through variables

Before we start coding, we should first set the foundations that will allow us to properly set up formats as well as ways of handling values, for example, nulls or dates. This is important because different regions have different formats. Let's take the United States as an example. Numbers in the United States use commas to represent thousands and dots to represent decimals. For example, one thousand and thirty hundredths in its numerical form is 1,000.30. However, most of the countries in Latin America would use dots as a thousand separator and commas for hundredths separators: 1.000,30.

Another very important value where the format changes depending on the region is the date. Dates can be represented ...