Qlik Sense auto num format always one decimal

[Aurelien_Martinez]

Hi community,

I'm using Qlik Sense April 2018 and I want to use auto format, with auto unit, but the number of decimal change every time .

It's possible to ALWAYS limit to one decimal ?

Thanks,

Aurélien

PS: I don't want a expression with multi num()

[balabhaskarqlik]

May you can define your Measure like this:

if(Sum(Sales) > 1000000,  num(Sum(Sales)/1000000, '#.##0,##M', ',', '.'),

    if(Sum(Sales) > 1000, num(Sum(Sales)/1000,  '#.##0,##K', ',', '.'), num(Sum(Sales), '#.##0,##', ',', '.')))

'#.##0,##M'

'#.##0,##K'

Then data will align to the above format.

Or

Select Number or Money format, modify the format like below:

if(Sum(Sales) > 1000000,  num(Sum(Sales)/1000000, '#.##0,##M', ',', '.'),

    if(Sum(Sales) > 1000, num(Sum(Sales)/1000,  '#.##0,##K', ',', '.'), num(Sum(Sales), '#.##0,##', ',', '.')))

'#.##0,##M'

'#.##0,##K'

[agigliotti]

could you show your expected result in chart object ?

[Aurelien_Martinez]

In this chart I have 2 decimals, but I want one (and keep auto unit)

[Aurelien_Martinez]

Thank you, but I would like to find another way

[agigliotti]

i guess you can't, why you don't use the custom number formatting ?

[Aurelien_Martinez]

When I display the data of the Group it's in billion and for subsidiary it's in million or in kilo. With custom formatting I'm losing this functionality.

[bradychen]

it's so easy to do that in PowerBI, I don't know why Qlik is not doing anything about it

We want to take advantage of the auto unit changing and at the same time being able to define the number of decimal places to be used. Has anyone found a solution yet?

[Ezirraffner]

Hi @Aurelien_Martinez 

Choice Measure expression 

And insert the expression:

Dual(Num(Sum(Sales)/Pow(10,3*(Div(Log10(Sum(Sales)),3))),'#.##0,0')&pick(div(Log10(Sum(Sales)),3),'k','M','B','T'),Sum(Sales))

I hope helps.

[bradychen]

Thanks pretty long one if I then have to use set analysis for each of the sum(sales) expression - this worked fine though.

The format should be '#,##0.0'