5 Replies Latest reply: Aug 14, 2017 2:21 PM by Sridhar Kasthuri RSS

    Number formatting in Qliksense Bar Chart

    Sridhar Kasthuri



      I have bar chart with Metrics Volume, Avg Selling Price and Margin % w.r.t Year. I am using Variable (Custom Extension Qlik Branch) to toggle the Metric on the Bar Chart but my bar shows only numbers. 


      I need to show Number in Millions for Volume, $ Sign for Avg Selling Price and % Sign for Margin beside the numbers on the chart. I used below statement but doesn't work


      if(vMetric=1, num(Sum(Volume),'#,##0.0M',

      if(vMetric=2,num(Avg(Selling Price),'$##.00',



      Let me know your suggestions please how to achieve this functionality.