Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

petber_exsitec
New Contributor III

Format of KPI object

Hi !

Is it possible to show 1,8G as 1 801M in a KPI-object? I have the value 1 801 002 003 and when I use the KPI object it's shown as 1,8G and that is correct because G stands for Giga. But I would like to show the value as 1 801 M instead. The is also correct because the values are the same.

I have tried to divide the value with 1000 but when I do that it's displayed as 1,8M and that is not what I'm looking for.

I have tried with a textbox and in that textbox I have full control of how the value should be displayed. But I would like to use the KPI-object.

Any ideas?

Best regards

Peter

1 Solution

Accepted Solutions

Re: Format of KPI object

Divide by 1000000 and set the custom format to #,##0 M

comm182198.png


talk is cheap, supply exceeds demand
2 Replies

Re: Format of KPI object

Divide by 1000000 and set the custom format to #,##0 M

comm182198.png


talk is cheap, supply exceeds demand
petber_exsitec
New Contributor III

Re: Format of KPI object

Thank you. It's almost what I'm looking for but I don't want the comma/ thousandseparator to show. It should be "1 801" not "1,801". I think this solution is good enough.

Community Browser