Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

simpleKPI extension doubt

i would like to know why does the kpi value changes from  something like this  - 495M to something like this  - 495,000,000?

i don't get how to fix this problem.

please help

1 Solution

Accepted Solutions
karthikoffi27se
Creator III
Creator III

Hi Pooja,

The KPI extension changes number formatting function from Millions to Decimal values if the 'Number Formatting' is amended from Auto to Number format.

Function_Name.PNG

Many Thanks

Karthik

View solution in original post

7 Replies
karthikoffi27se
Creator III
Creator III

Hi Pooja,

The KPI extension changes number formatting function from Millions to Decimal values if the 'Number Formatting' is amended from Auto to Number format.

Function_Name.PNG

Many Thanks

Karthik

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

What is the formula behind the numbers? What is your text formatting?

Anonymous
Not applicable
Author

pooja_biswas

May i know which chart you are using in qliksense. Please see the screen shot that is where the number format needs to be changed. Set the number format of that measure to auto that will fix the issue

Not applicable
Author

hi karthikeyan,

I checked the settings and number formatting is auto.

I actually copy pasted the thing and then it immediately changed. and thus enable to change it back

Not applicable
Author

formula is something like - Sum({<Type={'SALE'}>}Balance)

number formatting is auto

Not applicable
Author

hi vinay,

I am using an extension called simple KPI. I just copy pasted the chart to another sheet and this happened.

number formatting is still auto

simondachstr
Luminary Alumni
Luminary Alumni

Hey!

While you're at it, have a look at Vizlib's new supported KPI designer:

https://www.vizlib.com/kpi/

Keen to hear your thoughts!

Best,

Martin