Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Formatting numbers with currency

Hello, I'm having trouble representing numbers in french format. What I actually want to do is to have thousands separated by spaces, up to 2 decimals separated by a comma and a euro sign at the end separated by space ("2 845,99 €" e.g.).

I know how to do some of these things but not how to combine them :

To have spaces between thousands, I use the formula "# ##0" with "," as decimal separator and " " as thousands separator.

To have up to 2 digits after the comma and the euro sign, I use the expression "Round(mynumber,0.01)" and the formula "0,################ €" with the same separators.

I don't know how I can combine both to do what I want, do you know how I could do it ?

6 Replies
YoussefBelloum
Champion
Champion

Hi,

maybe you can try this:

num(YOUR_EXPRESSION,'# ##0,00')&' $'

hope it helps

prat1507
Specialist
Specialist

Use this ########### ###,00 

agigliotti
Partner - Champion
Partner - Champion

in your script use the settings below:

SET ThousandSep=' ';

SET DecimalSep=',';

SET MoneyThousandSep=' ';

SET MoneyDecimalSep=',';

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

and in your chart object set Money as format settings.

OmarBenSalem

Maybe try as follow directly using the qlik sense's formating tool; without the num function :

# ##0,00

Capture.PNG

Anonymous
Not applicable
Author

Hello, Andrea's answer works almost, I just don't have up to two numbers after the comma (2,40 -> 2,4) but I think that I will forget about this for currencies and only use it for other numbers.

How am I supposed to get "1 234,6" from 1234,56 ? (without the euro sign now)

Thank you for your answers.

OmarBenSalem

result:

Capture.PNG