topic Re: Number format as K in QlikView

Number format as K

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How can we convert numbers to K and M; (with HIDE AXIS on)

100.000 as 100 K

1.000.000 as 1 M

It happens when HIDE AXIS is off when when we take it off the numbers appear normally.

Thanks.

Re: Number format as K

sunny_talwar — Wed, 23 Mar 2016 13:33:38 GMT

How are you formatting them? on Numbers tab of chart properties or within the expression itself?

Re: Number format as K

avinashelite — Wed, 23 Mar 2016 13:33:42 GMT

Try like this

=If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'$#,###B'),

if(sum(Amount)/1000000>1,

Num(sum(Amount)/1000000,'$#,###M')

if(sum(Amount)/1000>1,Num(sum(Amount)/1000,'$#,###K')

)

Re: Number format as K

Anonymous — Wed, 23 Mar 2016 13:37:43 GMT

I am using CHART expression,

But is there a way to do it with NUMBER tab not with formula.

thnks.

Re: Number format as K

Anonymous — Wed, 23 Mar 2016 13:37:54 GMT

is there a way to do it with NUMBER tab not with formula.

thnks.

Re: Number format as K

sunny_talwar — Wed, 23 Mar 2016 13:40:16 GMT

AFAIK no. I guess the issue is that with number tab it behave the way it is programmed, not much can be configured. But with Expression option you have greater flexibility.