Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Dual(Replace(Num(Sum(field) / 1000000, '#,###0 M€'), ',', ' '), Sum(field) / 1000000)
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
I am not aware of a way to do it, but let me test it out.
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:
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€'
Hi Sunny,
I don't think these options exist in Qlik sense. Which actually is my problem
Juju
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