9 Replies Latest reply: Jan 31, 2018 2:51 AM by omar bensalem RSS

    stacked bar in qliksense

    John Smith

           Hi all,

       

      I would need help on the stacked bar chart in qliksense.

       

      I have 3 columns of data i.e Department, Revenue Original, Revenue Estimated.

      Now i have to calculate revenue ratio i.e revenue original / revenue estimated -

      who calculate the percentage (revenue original/revenue estimate) / total of both sum and if the ratio is <1 make it revenue failure if not revenue failure.

      and we need to count the number of revenue failure and revenue pass percentage.

      those percentage graph should be on bar chart .

       

      Ex is attached in the image and source spread sheet is also attached - please help me out