Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
deerhunter
Not applicable

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
praveenavelagap
Not applicable

Re: Sense number formatting using variables

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