Qlik Community

App Development

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

WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Getting error when displaying numbers in M and K


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)
0 Replies