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

    Number formatting in Qliksense Bar Chart

    Sridhar Kasthuri

      Hi,

       

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

      if(vMetric=3,num(Margin%),'##.00%')))

       

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

       

      Thanks