7 Replies Latest reply: Nov 18, 2015 10:56 AM by christian juillard

# Format numbers (in Qlik Sense)

Hi all

I am trying to format a number like # ##0 M€

I have 2 objects where I divide expression value like :  sum(field) / 1000000

- in the KPI object I used the custom number to set it up but the result I got for 3 227 200 000 is 322 7 M€  (note the blank place is not a mistake)

>> What I want is  3 227 M€

- in a pivot table I used the Money number format and I get  3 227,20€

>> What I want is to set a money format without decimal like 3 227 M€

thank you for your help

juju

• ###### Re: Format numbers (in Qlik Sense)

Try this:

=Dual(Replace(Num(Sum(field) / 1000000, '#,###0 M€'), ',', ' '), Sum(field) / 1000000)

• ###### Re: Format numbers (in Qlik Sense)

Thank you Sunny

but this is not working either

And my question is how can I modify format number in the Data/Measure/Number formatting) area if it is possible

may be it is not and in this case I will format my expression

juju

• ###### Re: Format numbers (in Qlik Sense)

I am not aware of a way to do it, but let me test it out.

• ###### Re: Format numbers (in Qlik Sense)

Don't have too much experience with Qlik Sense, but if you can find Separators you might be able to do something similar to what QlikView allows:

• ###### Re: Format numbers (in Qlik Sense)

Hi Sunny,

I don't think these options exist in Qlik sense. Which actually is my problem

Juju

• ###### Re: Format numbers (in Qlik Sense)

I think you may have to use the three parameter form of num and concatenate the currency string (because it has a space)

=num(sum(LineSalesAmount) / 1000

,'# ##0'

,'.',' ')

& ' K€'

• ###### Re: Format numbers (in Qlik Sense)

Hi Rob,

thank you.

Yes sure this solution works in expression area

My goal was to find the way to format number in Number Formatting area

But I think we can assume there are less possibilities with QS than in QV

best regards

Juju