topic Pivoting in QlikView in QlikView https://community.qlik.com/t5/QlikView/Pivoting-in-QlikView/m-p/301247#M1199294 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>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.</P><P>Now to the problem.</P><P>I have a table which holds asset related data. e.g</P><P>i&gt;Mark,TV</P><P>ii&gt;Mark,Fridge</P><P>iii&gt;Jo,Notebook</P><P>iv&gt;Gail,House</P><P>v&gt;Henry,Car</P><P>...etc</P><P>What I need to know is that, is there a way to get the data into a single row; an asset matrix</P><P>e.g</P><P>Name-Car-Fridge-House-Notebook-TV</P><P>Mark - 0 - 1 - 0 - 0 - 1</P><P>Jo - 0 - 0 - 0 - 1 - 0</P><P>Gail - 0 - 0 - 1 - 0 - 0</P><P>Henry - 1 - 0 - 0 - 0 - 0</P><P>The problem is, the assets may keep increasing so hardcoding is not the solution that I'm looking for.</P><P>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.</P><P>Any help is appreciated.</P><P>Regards,</P><P>Pritam</P><P></P><P></P></BODY></HTML> Tue, 25 Jan 2011 19:09:34 GMT 2011-01-25T19:09:34Z Pivoting in QlikView https://community.qlik.com/t5/QlikView/Pivoting-in-QlikView/m-p/301247#M1199294 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>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.</P><P>Now to the problem.</P><P>I have a table which holds asset related data. e.g</P><P>i&gt;Mark,TV</P><P>ii&gt;Mark,Fridge</P><P>iii&gt;Jo,Notebook</P><P>iv&gt;Gail,House</P><P>v&gt;Henry,Car</P><P>...etc</P><P>What I need to know is that, is there a way to get the data into a single row; an asset matrix</P><P>e.g</P><P>Name-Car-Fridge-House-Notebook-TV</P><P>Mark - 0 - 1 - 0 - 0 - 1</P><P>Jo - 0 - 0 - 0 - 1 - 0</P><P>Gail - 0 - 0 - 1 - 0 - 0</P><P>Henry - 1 - 0 - 0 - 0 - 0</P><P>The problem is, the assets may keep increasing so hardcoding is not the solution that I'm looking for.</P><P>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.</P><P>Any help is appreciated.</P><P>Regards,</P><P>Pritam</P><P></P><P></P></BODY></HTML> Tue, 25 Jan 2011 19:09:34 GMT https://community.qlik.com/t5/QlikView/Pivoting-in-QlikView/m-p/301247#M1199294 2011-01-25T19:09:34Z