Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jujucts
Partner - Creator II
Partner - Creator II

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

7 Replies
sunny_talwar

Try this:

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

jujucts
Partner - Creator II
Partner - Creator II
Author

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:

Capture.PNG

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Creator II
Partner - Creator II
Author

Hi Sunny,

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

Juju

jujucts
Partner - Creator II
Partner - Creator II
Author

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