topic Re: shorting the number in QlikView

shorting the number

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

Hi all,

I want to convert the my expression like 30000 into 30k,500000 into 50m in Bar Chart.Please let me know step by step.

Regards

Manu

Anonymous — Sun, 18 Mar 2018 21:51:30 GMT

in expression...

num(sum(dimenson/1000), '###K')

Anonymous — Mon, 19 Mar 2018 00:57:51 GMT

=If(sum(<your measure>)/1000000 > 1 //check if more than million

,Num(sum(<your measure>)/1000000 ,'#,##0M') // in million

, Num(sum(<your measure>)/1000 ,'#,##0K')) // in K

Siva_Sankar — Mon, 19 Mar 2018 02:25:37 GMT

Hi Manu,

Try the below expression, replace your YourExpressionHere with your measure

=If(sum(YourExpressionHere)/1000000000 > 1,Num(sum(YourExpressionHere)/1000000000,'$#,###B'), Num(sum(YourExpressionHere)/1000000,'$#,###M'))

-Siva

Anonymous — Mon, 19 Mar 2018 05:13:41 GMT

Hi,

Alternatively, Please see the below image: