6 Replies Latest reply: Feb 26, 2016 2:16 AM by kishore pandurangan RSS

    Creating a Pivot Table

    Ridhaa Hendricks

      Hi There


      I am trying to create a pivot table and using the totals from the expression I would like to do a calculation

      what would be the simplest way to do this.


          Total is the Partial sums of the dimension "Factory" , Total Prediction is the total/1*12 , for Docs (2000/1*12=24000)

      how can I do this in Qlikview ?


      SupplierShop 1Shop 2Shop 3Shop 5TotalTotal Prediction
      Peters Paper4000400048000
      Williams Plastics5000500060000


      Your assistance is appreciated.