Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deerhunter
Creator
Creator

Sense number formatting using variables

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?

1 Reply
Anonymous
Not applicable

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