Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

juju1204
Contributor

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

Re: Format numbers (in Qlik Sense)

Try this:

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

juju1204
Contributor

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:

Capture.PNG

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

juju1204
Contributor

Re: Format numbers (in Qlik Sense)

Hi Sunny,

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

Juju

juju1204
Contributor

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

Community Browser