Sense number formatting using variables

[deerhunter]

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?

[Anonymous]

It will not work in charts of Qlik Sense with multiple If clauses and Num function , It will only work in KPI's.