1 Reply Latest reply: Sep 28, 2016 12:52 PM by Walter Coleman RSS

    Number Formatting in Sense

    Walter Coleman

      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?