topic Re: KPI number formatting in App Development

KPI number formatting

ilanbaruch — Sat, 16 Nov 2024 18:13:26 GMT

hi all,

in my model i use native qlik KPI's

i want to keep B M K number formatting but to add one decimal i/e :

instead of 6.57 -> to present 6.573M

any ideas ?

advanced thanks

Re: KPI number formatting

Kushal_Chawda — Sun, 16 Aug 2020 14:24:01 GMT

You can provide custom format like below

Re: KPI number formatting

ilanbaruch — Sun, 16 Aug 2020 14:31:14 GMT

thank you Kush

bu how to add the M \ K \ B ?

Re: KPI number formatting

Ksrinivasan — Sun, 16 Aug 2020 14:34:49 GMT

hi,

i have workaround solution

1. your value / 1000000

2. set KPI heading like Value in Millions,

3. Change Number formatting from Auto to Number and Change Number pattern #.##0.00 to #.###0.000 as give below

Re: KPI number formatting

Kushal_Chawda — Sun, 16 Aug 2020 18:04:15 GMT

try below

=pick(match(-1,YourExpression>=1000000000,YourExpression>=1000000,YourExpression>=1000),
num(YourExpression/1000000000 ,'#,##0.000 B'),
num(YourExpression/1000000 ,'#,##0.000 M'),
num(YourExpression/1000,'#,##0.000 K'))

Now you can use measure expression as format like below

Re: KPI number formatting

ilanbaruch — Tue, 18 Aug 2020 07:14:00 GMT

thank you!

Re: KPI number formatting

aheavy95 — Tue, 17 May 2022 14:27:46 GMT

Hi I used this calculation

in my project and for some reason it doesnt work for me when I add part of a set analysis:

pick(vKPI_TOTAL_NET,$(vScaleNumber2(Sum({$<Year={2007}>}TotalDue))),$(vScaleNumber2(Sum({$<Year={2007}>}SubTotal_SO))))

it works here but when I add the months it doesnt anymore:

pick(vKPI_TOTAL_NET,$(vScaleNumber2(Sum({$<Year={2007},[Month Num]={7,8,9,10,11,12}>}TotalDue))),$(vScaleNumber2(Sum({$<Year={2007}>}SubTotal_SO))))

any idea why?

Re: KPI number formatting

Danica-Cortez — Wed, 17 Jan 2024 23:53:35 GMT

As of Jan 2024, you can simply use a combination of setting numerical abbreviations in the load script

AND specifying decimal in "Format pattern" in the measure section (ie, change automatic format of 0A to your desired precision 0.0A, etc.)

Re: KPI number formatting

ElisaF — Mon, 22 Jan 2024 17:02:48 GMT

Hi @Danica-Cortez

Please, can you tell me which version of QlikSense you have the options from the image above (Number Formatting: Auto with Format pattern 0.0A).

In which QlikSense objects? Can be applied into #KPI?

Thank you

Re: KPI number formatting

Danica-Cortez — Mon, 22 Jan 2024 17:49:49 GMT

I can't manage to see which version of Qlik Sense, but I am using the Multi KPI viz.