6 Replies Latest reply: Nov 7, 2017 8:40 AM by Manuel Tertre

Formatting numbers with currency

Manuel Tertre Nov 7, 2017 7:50 AM

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 ?

Re: Formatting numbers with currency

youssef belloum Nov 7, 2017 8:14 AM (in response to Manuel Tertre)

Hi,

maybe you can try this:

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

hope it helps
Like Show 0 Likes (0)

Actions
Re: Formatting numbers with currency

Pratyush Shastri Nov 7, 2017 8:18 AM (in response to Manuel Tertre)

Use this ########### ###,00 €
Like Show 0 Likes (0)

Actions
Re: Formatting numbers with currency

Andrea Gigliotti Nov 7, 2017 8:24 AM (in response to Manuel Tertre)

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.
Like Show 1 Like (1)

Actions
Re: Formatting numbers with currency

omar bensalem Nov 7, 2017 8:41 AM (in response to Manuel Tertre)

Maybe try as follow directly using the qlik sense's formating tool; without the num function :
# ##0,00 €
Like Show 0 Likes (0)

Actions
- Re: Formatting numbers with currency
  
  omar bensalem Nov 7, 2017 8:47 AM (in response to omar bensalem )
  
  result:
  
  Like Show 0 Likes (0)
  
  Actions
Re: Formatting numbers with currency

Manuel Tertre Nov 7, 2017 8:40 AM (in response to Manuel Tertre)

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.
Like Show 0 Likes (0)

Actions

Go to original post