Number Formatting in Sense

Wed, 28 Sep 2016 15:17:52 GMT

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?

Re: Number Formatting in Sense

Wed, 28 Sep 2016 16:52:34 GMT

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

)));

topic Re: Number Formatting in Sense in App Development

Number Formatting in Sense

Re: Number Formatting in Sense