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()

[Ezirraffner]

Unfortunately, I believe it is not possible to have this automatic format yet.

Really the format should be

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))

It was different because my locale 🙂

[fashid]

Is this feature now available in the latest release 

[willian_zilli]

My solution as follow:

Round(total_sales, Pow(10, Floor(Log10(total_sales))-Mod(Floor(Log10(total_sales)), 3)) * 0.1)

[taha_mansoor]

@Ezirraffner  the below expression does not work when the figure goes negative. Any fixture or suggestions for this please ? 

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))