How to change Windows regional settings and have them apply to Qlik Sense

[Sonja_Bauernfeind]

It is possible to change the Regional settings of Windows to be reflected in Qlik Sense.

The steps outline in this article explains how to change the regional settings from English (United States) to German (Germany). 

More information also under Change the Windows regional settings to modify the appearance of some data types 

Resolution

1. From the Windows control panel, select to Change date, time or number formats.
2. In the Region window and tab Formats, please select the appropriate country and click Apply (see image below)
   
   
   
   
3. Go to the Location tab, change the Home location to your country of preference and click Apply (image below)
   
   
   
   
4. In-suite change the System locale in the Administrative tab,  click OK and Apply.
5. Do not restart the server yet.
   
   
   
   
6. Click on "Copy settings..." in the Administrative tab, then flag the "Welcome screen and system accounts" option in the windows that opens (see image below).
   
   
   
   
7. Click OK, Apply and restart Windows server.
8. As another example, if you would like to modify the data separator in files exported to excel/csv:
   - Go to the Numbers tab, under 'List Separator'
   you can modify the separator to either semicolon (;) or coma (,) (or any other delimiter)-> apply and export to excel/csv...
   
   
   

Related Content:

Change the Windows regional settings to modify the appearance of some data types 

[Narges]

Hi Sonja,

Is that an immediate change or should be done before system installation or any service account restart is required?

When we do changes in the server region settings how we can make sure it applied in Qlik Sense?

Thanks

[Sonja_Bauernfeind]

Hello @Narges 

You will need to restart the server at step 7. 

You would see if the changes are applied if Qlik Sense correctly changes its language used and/or if the delimiter used when exporting has now changed.

All the best,
Sonja