Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

KPI number format

Hi

I have a KPI with a number of 2G , but want that to be in decimals like 1.88G.

Exampl: now 1.55G is depicted as 2G, just as 2.49G is.

Can't seem to manage though since adjusting the settings for number format results in the entire number (1.880.246.321,6)

thanks

5 Replies

Re: KPI number format

What is the expression you are using right now?

Re: KPI number format

May be this:

Num(Expression, '##.00G')

Not applicable

Re: KPI number format

does not work, but thanks!

Re: KPI number format

What is your current expression?

Khan_Mohammed
Honored Contributor II

Re: KPI number format

You must have tried this but have you checked the Number formatting>Custom>Number>Change it to a decimal after number.

Like below imageFormat.PNG

Format.PNG