Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Contributor III

Re: simpleKPI extension doubt

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

7 Replies
karthikoffi27se
Contributor III

Re: simpleKPI extension doubt

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
Valued Contributor II

Re: simpleKPI extension doubt

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

vinay_bangari
Valued Contributor III

Re: simpleKPI extension doubt

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

Re: simpleKPI extension doubt

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

Re: simpleKPI extension doubt

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

number formatting is auto

Not applicable

Re: simpleKPI extension doubt

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
Valued Contributor III

Re: simpleKPI extension doubt

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