Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aurelien_Martinez
Partner - Specialist
Partner - Specialist

Qlik Sense auto num format always one decimal

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

Help users find answers! Don't forget to mark a solution that worked for you!
13 Replies
Ezir
Creator II
Creator II

 

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

Is this feature now available in the latest release 

willian_zilli
Contributor
Contributor

My solution as follow:

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

taha_mansoor
Creator
Creator

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