1 Reply Latest reply: Sep 15, 2016 5:31 PM by Praveena Velagapudi RSS

    Sense number formatting using variables

    Buck Master

      In Qlik Sense, I have not seen anyone show how to format Sum(sales) results  across sheets outside of manually doing it all places like: '$#,##0M;($#,##0M)'

       

      In Qlikview you could use the following:

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

      )));

       

      And in your object: =$(vScaleNumber(Sum(Sales)))

       

      And it would format the number results automatically using one variable for all cases.

      Can anyone make this work in Qlik Sense?