0 Replies Latest reply: Jan 25, 2011 2:09 PM by Pritam Deb RSS

    Pivoting in QlikView

    Pritam Deb

      Hi All,

      This is my first post and I would be very thankful to anyone who can help me out with this problem or perhaps point me in the right direction.

      Now to the problem.

      I have a table which holds asset related data. e.g

      i>Mark,TV

      ii>Mark,Fridge

      iii>Jo,Notebook

      iv>Gail,House

      v>Henry,Car

      ...etc

      What I need to know is that, is there a way to get the data into a single row; an asset matrix

      e.g

      Name-Car-Fridge-House-Notebook-TV

      Mark - 0 - 1 - 0 - 0 - 1

      Jo - 0 - 0 - 0 - 1 - 0

      Gail - 0 - 0 - 1 - 0 - 0

      Henry - 1 - 0 - 0 - 0 - 0

      The problem is, the assets may keep increasing so hardcoding is not the solution that I'm looking for.

      Though this can be achieved in SQL using a dynamic pivot, is it possible to achieve the same through QlikView or am I missing something here.

      Any help is appreciated.

      Regards,

      Pritam