Format numbers (in Qlik Sense)

[jujucts]

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

[sunny_talwar]

Try this:

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

[jujucts]

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

[sunny_talwar]

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

[sunny_talwar]

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:

[rwunderlich]

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€'

[jujucts]

Hi Sunny,

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

Juju

[jujucts]

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