Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
csweeren
Contributor
Contributor

Qlik Sense Desktop vs. Server difference in data load (. ~ ,)

Hello Community,

I'm facing an behavior i can´t identify the root cause. My desktop app loads data from salesforce  (Qlik Salesforce Connector) and when i browse the data (numbers/amount of xy) i can see those values in the data manager are shown like 54,85.

Should be correct as i´m located in europe and use number formats 123.456,78.

Using the same app (same data connection) on our cloud (AWS) server with Qlike Sense Server it shows the same data but in a different formatting 54.85. I tried to change the number format of the windows OS from US to Europe. But it doesn't affect the data shown in the data manager.

Also changing the SET parameters doesn't affect how the data is shown in the data manager.

  SET ThousandSep=',';

  SET DecimalSep='.';

  SET MoneyThousandSep='.';

  SET MoneyDecimalSep=',';

  SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

So my assumptions is that maybe the OS number format present at installation time is used later on, independent of the current selected number format in windows. I saw that calculation methods e.g. Num# [1] are related to the OS.

Thanks for the help in advance and any ideas are welcome.

[1]Num# ‒ Qlik Sense

0 Replies