3 Replies Latest reply: May 22, 2017 8:05 AM by Magdalena Tudose RSS

    Bar Graph:Not able to show both percentage and number

    Supriya R

      Hi,

       

      i have a graph in qliksense where i want to show both number and percentage in the graph. But it always displays sum number. i want to show  

      value data points in this format

      45(23%)

       

      script code:

       

      Table:

      Load * inline

      [Type,campaign,sum

      Deliverd,c1,34

      Deliverd,c2,4

      Deliverd,c3,56

      Opened,c3,23

      Opened,c1,20

      Opened,c2,5

      CTR,c1,45

      CTR,c2,12

      CTR,c3,15

      ];

       

       

      FinalData:

      Load

      Type,

      campaign,

      sum,

      dual(sum & ' (' & num(sum/2,'0%') & ')', sum) as dual_data

      Resident Table;

      drop Table Table;

       

      But using above i am not able to display in required format.

      How to do this? Please help me on this.