3 Replies Latest reply: Jan 10, 2016 2:17 PM by Gysbert Wassenaar RSS

    Relative value total in the bar chart using Qlik Sense

      Hi Experts,


      I have a requirement to show relative value totals by dimension in Qlik sense. I have a table as follows


      Company NameSales Total
      Innovation  Industries50000
      online Income pvt Limited70000
      Entreprenette pvt Limited35000
      Recycled Products pvt limited40000


      My output should be as follows when I selected first company (Innovation Industries) in the filter then the relative totals of the rest of the companies looks like below

      Filter : Innovation  Industries (50000)

      Company NameRelative Sales TotalLogic to derive
      online Income pvt Limited-2000050000-70000 = -20000
      Entreprenette pvt Limited1500050000-35000 = 15000
      Recycled Products pvt limited1000050000-40000 = 10000


      Please let me know how can i achieve this using expressions in the Qliksense. Please help me out on this.

      Thanks in advance.