topic Re: Transpose? Crosstable? Generic Load? in QlikView https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480863#M555531 <HTML><HEAD></HEAD><BODY><P>Yes that sounds like it would do the trick&nbsp; - i can't seem to work out how to drag the column (Job Role) though?&nbsp; I've attached my qvw if someone could take a quick look that would be great.&nbsp; </P></BODY></HTML> Fri, 09 Aug 2013 13:34:11 GMT haymarketpaul 2013-08-09T13:34:11Z Transpose? Crosstable? Generic Load? https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480860#M555528 <HTML><HEAD></HEAD><BODY><P>QV11 SR2</P><P></P><P>I'm trying to work out the best way to transpose the following data.&nbsp; I've been looking at possibly using transpose, crosstable or generic load but i'm not quite which if any are the best to use.&nbsp; Any advice much appreciated.</P><P></P><P><IMG __jive_id="45209" class="jive-image" alt="Data.gif" src="https://community.qlik.com/legacyfs/online/45209_Data.gif" /></P><P></P><P>This is the format i am trying to achieve...</P><P></P><P><IMG __jive_id="45210" class="jive-image-thumbnail jive-image" height="76" onclick="" alt="Result.gif" src="https://community.qlik.com/legacyfs/online/45210_Result.gif" width="844" /></P></BODY></HTML> Fri, 09 Aug 2013 11:52:08 GMT https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480860#M555528 haymarketpaul 2013-08-09T11:52:08Z Re: Transpose? Crosstable? Generic Load? https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480861#M555529 <HTML><HEAD></HEAD><BODY><P>If I've understood it correctly, you could create a pivot table and then just drag the Interest Area Dimension to the top of the table, and It will appear just the way you want.</P><P></P><P>Hope this helps.</P><P></P><P><IMG alt="Sin título.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/45211_Sin+t%C3%ADtulo.png" /></P></BODY></HTML> Fri, 09 Aug 2013 12:03:42 GMT https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480861#M555529 2013-08-09T12:03:42Z Re: Transpose? Crosstable? Generic Load? https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480862#M555530 <HTML><HEAD></HEAD><BODY><P>Can you load this full data into qlikview and then convert it using pivot chart in the way you want?</P></BODY></HTML> Fri, 09 Aug 2013 12:09:29 GMT https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480862#M555530 anandathome 2013-08-09T12:09:29Z Re: Transpose? Crosstable? Generic Load? https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480863#M555531 <HTML><HEAD></HEAD><BODY><P>Yes that sounds like it would do the trick&nbsp; - i can't seem to work out how to drag the column (Job Role) though?&nbsp; I've attached my qvw if someone could take a quick look that would be great.&nbsp; </P></BODY></HTML> Fri, 09 Aug 2013 13:34:11 GMT https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480863#M555531 haymarketpaul 2013-08-09T13:34:11Z Re: Transpose? Crosstable? Generic Load? https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480864#M555532 <HTML><HEAD></HEAD><BODY><P>Please find attached.</P><P></P><P>You have to drag the Interest Area </P><P>field and take it to the right and to the top of column name, it shows a blue line.</P><P>Drop it at the top of column name.</P></BODY></HTML> Fri, 09 Aug 2013 13:37:41 GMT https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480864#M555532 anandathome 2013-08-09T13:37:41Z Re: Transpose? Crosstable? Generic Load? https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480865#M555533 <HTML><HEAD></HEAD><BODY><P>Ah Got it - Thank you Anand</P></BODY></HTML> Fri, 09 Aug 2013 13:43:46 GMT https://community.qlik.com/t5/QlikView/Transpose-Crosstable-Generic-Load/m-p/480865#M555533 haymarketpaul 2013-08-09T13:43:46Z