2 Replies Latest reply: Apr 5, 2017 12:23 PM by omar bensalem RSS

    Pivot data in Qlik table

    Edward Carlile

      I have a data set like this:

       

      StoreItemOn Hand
      A150,000
      A220,000
      A310,000
      B190,000
      B295,000
      C1500,000
      C25,000,000
      C390,000
      C4950,000

       

      I need to create a chart in Qlik Sense Desktop which will show this:

       

      StoreItem 1Item 2Item 3Item 4
      A50,00020,000
      10,000
      0
      B90,00095,00000

       

      I guess its a simple pivot... i'm just coming up blank at the moment.