Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

phultman
New Contributor

Money format issues (both app and export)

I am struggling to get the money format correct in my apps.

In the script I have the following settings:

SET ThousandSep=' ';

SET DecimalSep=',';

SET MoneyThousandSep=' ';

SET MoneyDecimalSep=',';

SET MoneyFormat='# ##0,00 kr;-# ##0,00 kr';

SET TimeFormat='hh:mm:ss';

SET DateFormat='YYYY-MM-DD';

SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

The measure I present is coded like this:

Money(Sum(count*netprice))


In a pivot table it looks correct:

1.PNG

But when exporting to Excel it looks like this (missing spaces):

3.PNG


In a bar chart it looks like this (spaces missing):

2.PNG


And when exporting to Excel I get this (spaces still missing):

4.PNG


If I change the number format in my bar chart from "auto" to "currency" I get this:

5.PNG


And when exporting to Excel I get this (values are correct but presentation is divided by 1000):

6.PNG


I would be very grateful if someone could explain to me what is going on and how to get it right


/Peter

2 Replies
praveenkumar_ma
Contributor

Re: Money format issues (both app and export)

Hi Peter,

Check the ThousandSep Once in ur Script , i am seeing Blanks . compare with Default Script down ..

your Script has Blank Settings in Thousandsep

and MoneyThousandSep

and

MoneyDeccimalSep should be '.';

in your case it is ',' ;

SET ThousandSep=' ';

SET DecimalSep=',';

SET MoneyThousandSep=' ';

SET MoneyDecimalSep=',';

SET MoneyFormat='# ##0,00 kr;-# ##0,00 kr';

SET TimeFormat='hh:mm:ss';

SET DateFormat='YYYY-MM-DD';

SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]';

Normal Default Script :

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='hh:mm:ss';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY hh:mm:ss[.fff]';

This might be Helpful to process furthur...

Thanks

PM

phultman
New Contributor

Re: Money format issues (both app and export)

Hi Praveen,

Thanks, put It depends on what locale you are using.

I want to have Swedish notation. Hence space and ','.

/Peter

Community Browser