Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am struggling to get the money format correct in my apps.
In the script I have the following settings:
SET ThousandSep=' ';
SET MoneyThousandSep=' ';
SET MoneyFormat='# ##0,00 kr;-# ##0,00 kr';
SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';
The measure I present is coded like this:
In a pivot table it looks correct:
But when exporting to Excel it looks like this (missing spaces):
In a bar chart it looks like this (spaces missing):
And when exporting to Excel I get this (spaces still missing):
If I change the number format in my bar chart from "auto" to "currency" I get this:
And when exporting to Excel I get this (values are correct but presentation is divided by 1000):
I would be very grateful if someone could explain to me what is going on and how to get it right
Check the ThousandSep Once in ur Script , i am seeing Blanks . compare with Default Script down ..
your Script has Blank Settings in Thousandsep
MoneyDeccimalSep should be '.';
in your case it is ',' ;
Normal Default Script :
SET TimestampFormat='M/D/YYYY hh:mm:ss[.fff]';
This might be Helpful to process furthur...
Thanks, put It depends on what locale you are using.
I want to have Swedish notation. Hence space and ','.