Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
nazaninslp
New Contributor III

Getting error when displaying numbers in M and K

Dears

I want to show my numbers in Million and K.

I've searched and write following expression but it display wrong for number which is below 1 M.

for example attached file should show 500 K NOT 0M.

would you please help.

I've attached my file

 

Expression: =if(sum(REVENUE)>10000000,num(sum({<Year={"$(=Max(Year))"},Area_Category-={"Test","Free ShortCode","Xtratime","ACS"}>}REVENUE)/10000000, '#,##0M'),
if(sum(REVENUE)<=10000000,num(sum({<Year={"$(=Max(Year))"},Area_Category-={"Test","Free ShortCode","Xtratime","ACS"}>}REVENUE)/10, '#,##0K'),num(Sum(REVENUE),'#,##0')))

Labels (2)