Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.