Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

number formatting in KPI

Hi All,
Is it possible to change the number formatting of KPI, currently value is coming as 60.15M but wanted to just value to 1 decimal i.e. 60.1M.
Number formatting is set to Auto but I don't want to change the number formatting
Please suggest.

Qlik1_User1_1-1656323383795.png

 

Labels (6)
4 Replies
Chanty4u
MVP
MVP

The format should be '#,##0.0'

Or
MVP
MVP

As far as I know, it is not possible to change the formatting of numbers in KPI without changing the formatting of numbers in KPI. You could write up some sort of complex rounding/formatting formula and use the "Measure expression" setting, but even that would require switching off "Auto".

Qlik1_User1
Specialist
Specialist
Author

@Or 

True, is there any way that while keeping number format to Auto, number formatting comes in B,M,K format?

Or
MVP
MVP

If you set the format to auto, then the format will be automated and you won't be able to control it.

There's any number of past discussions on this site about manually adjusting the format to include letters using if() and num() statements, you can look them up if you'd like to go that route.