Qlik Community

Qlik Sense App Development

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

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

Number Formatting in Sense

In Qlikview we are able to define a variable to automate the delivery of chart number presented in visualizations. I tried the following and it did not work.

SET vSize = Div(Log10($1),3);

SET vFormatNumber = Dual(Num($1/Pow(10,3*$(vSize($1))),'#,##0')&' '&Pick($(vSize($1)),'K','M','B','T'),$1);

I also understand that you can set it up within every measure, but that will mean if changes are required i'll need to do it everywhere.

Has anyone had any success doing this with variables in Sense?

1 Reply
Not applicable

Re: Number Formatting in Sense

I also tried the following that did not work:

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')

)));