Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Qlik Sense, I have not seen anyone show how to format Sum(sales) results across sheets outside of manually doing it all places like: '$#,##0M;($#,##0M)'
In Qlikview you could use the following:
SET vScaleNumber=if($1>1E9, num($1/1E9,'$#,##0.000B')
,if($1>1E6, num($1/1E6,'$#,##0.000M')
,if($1>1E3, num($1/1E3,'$#,##0.000K')
,num($1,'$#,##0')
)));
And in your object: =$(vScaleNumber(Sum(Sales)))
And it would format the number results automatically using one variable for all cases.
Can anyone make this work in Qlik Sense?
It will not work in charts of Qlik Sense with multiple If clauses and Num function , It will only work in KPI's.