
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
qliksense KPI one decimal
Hello All,
I am using Simple KPI Extension and Standard Qliksense #1 KPI object to display Total Sales. Simple KPI Shows values such 35M, 30K, etc Standard KPI shows 35.41M, 30.33K etc. what I am looking is Values such as 35.4M, 30.3K with decimal values, can you please help on this.
Thanks
Raj
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You probably might have tried this already but want to check anyway: What happens when you select Number formatting as 'Custom' (instead of auto) and in the Format pattern text box use this : "#,##0.0".

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Nakul,
When I change to custom format to as you mentioned, then values displays completely like 30,300,167.99. but I would like to see 30.3M that is way I am using custom formula based on Rob formula which is given below again.
SET vScaleNumber=if($1>1000000, num($1/1000000,'#,##0.000M')
,if($1>1000, num($1/1000,'#,##0.000K')
,num($1,'#,##0')
));
then use expression $(vScaleNumber(sum(InvoiceValue)))
this code is working fine without decimals. but I wanted with 1 decimal.
Raj

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what happens when you change the formula to this:
SET vScaleNumber=if($1>1000000, num($1/1000000,'#,##0.0M')
,if($1>1000, num($1/1000,'#,##0.0K')
,num($1,'#,##0.0')
));


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Raju,
Is this what you are trying to achieve?
This was accomplished with Gysbert's previous answer:
=pick(ceil(log10(sum(Sales))/3),
num(sum(Sales),'#,##0.0'),
num(sum(Sales)/1000,'#,##0.0 K'),
num(sum(Sales)/1000000,'#,##0.0 M')
) & ''

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Michael,
Yes, this is what I wanted, thank you and Gysbert. This is working fine and this is correct Answer for Dynamic KPI values for 1 decimal.
Thanks
Raj

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Michael,
That expression worked fine in a Table, but in a Line Chart it is not working, it doesn't show anything. Can you help me with that?
Thanks!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you tried just doing the expression without the formatting? Using the example above it would just be sum(Sales). A line chart should format as needed.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Michael,
What I want is to have the auto number formatting (K, M, G) but with just 1 decimal. Using the expression in a table gives me the format I want with just 1 decimal, but in a bar or line chart it does not work, it shows nothing.

- « Previous Replies
-
- 1
- 2
- Next Replies »