Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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')
)));