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: 
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
Author

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

)));