Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ngulliver
Partner - Specialist III
Partner - Specialist III

Displaying Euros - how do you show decimal place as a comma in free text?

I have a requirement to display monetary amounts in Euros. Therefore, thousands use '.' separator whereas cents use ',' separator.

(e.g. 5 thousand euros and 35 cents = 5.000,35).

Whilst this is straight forward to change this within the Numbers tab, I am having some difficulty when using it in chart titles and any free text.

I have written the following:

replace(num(sum(fieldname), '##.#0'),'.',',')

using replace to get the . to appear as ,

However, I am struggling to find a way of separating the thousand with a decimal point. This is particularly a problem when the numbers are in the millions and you need more than one decimal point (e.g. Euros 9248563,05 needs to be 9.248.563,05).

Has anyone found a way of getting round this ?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe using the standard format variables in your script:

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

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

and then as expression

=money(sum(fieldname))

Hope this helps,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe using the standard format variables in your script:

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

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

and then as expression

=money(sum(fieldname))

Hope this helps,

Stefan

ngulliver
Partner - Specialist III
Partner - Specialist III
Author

Hi, Stefan.

That worked perfectly once I took your suggestion and added the decimal places in the spaces you had provided.

I put in

SET MoneyThousandSep='. ';

SET MoneyDecimalSep=',';

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

Many thanks,

Neil