topic Re: trying to convert row to column in QlikView https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581895#M216133 <HTML><HEAD></HEAD><BODY><P>Hi if you are showing in pivot table just drag and drop that field otherwise go for cross table</P></BODY></HTML> Fri, 28 Feb 2014 06:06:53 GMT 2014-02-28T06:06:53Z trying to convert row to column https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581891#M216129 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P><P></P><P>I am new to qlikview. I want convert a row to column.</P><P></P><P>The input&nbsp; is like this-</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>column1&nbsp; companycode1&nbsp;&nbsp;&nbsp; column2&nbsp;&nbsp; companycode2&nbsp; companycode3.......companycode12&nbsp; </P><P>a</P><P>b</P><P>c</P><P>d</P><P>e</P><P></P><P></P><P></P><P>My output should be like:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>companycode&nbsp;&nbsp;&nbsp;&nbsp; company name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp; 2&nbsp;&nbsp; 3&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; column2 </P><P>companycode1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cn1</P><P>companycode2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cn2 </P><P>companycode3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cn3</P><P></P><P></P><P></P><P>I have another file which is</P><P></P><P>companycode&nbsp;&nbsp;&nbsp;&nbsp; company name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>companycode2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cn2 </P><P>companycode3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cn3</P><P></P><P></P><P></P><P>....</P></BODY></HTML> Fri, 28 Feb 2014 05:51:10 GMT https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581891#M216129 2014-02-28T05:51:10Z Re: trying to convert row to column https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581892#M216130 <HTML><HEAD></HEAD><BODY><P>Learn and try CROSSTABLE</P></BODY></HTML> Fri, 28 Feb 2014 05:55:14 GMT https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581892#M216130 tresB 2014-02-28T05:55:14Z Re: trying to convert row to column https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581893#M216131 <HTML><HEAD></HEAD><BODY><P>PFA Sample application for Cross Table.</P><P></P><P>Vikas</P></BODY></HTML> Fri, 28 Feb 2014 06:01:10 GMT https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581893#M216131 vikasmahajan 2014-02-28T06:01:10Z Re: trying to convert row to column https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581894#M216132 <HTML><HEAD></HEAD><BODY><P>Trying using a Pivot table and then hold press the columns to get the blue line and then drag and drop accordingly.</P><P></P><P>Thanks,</P><P>Angad</P></BODY></HTML> Fri, 28 Feb 2014 06:06:21 GMT https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581894#M216132 2014-02-28T06:06:21Z Re: trying to convert row to column https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581895#M216133 <HTML><HEAD></HEAD><BODY><P>Hi if you are showing in pivot table just drag and drop that field otherwise go for cross table</P></BODY></HTML> Fri, 28 Feb 2014 06:06:53 GMT https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581895#M216133 2014-02-28T06:06:53Z Re: trying to convert row to column https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581896#M216134 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>while loading data got to rotate tab-&gt;Transpose.</P></BODY></HTML> Fri, 28 Feb 2014 06:15:44 GMT https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581896#M216134 PrashantSangle 2014-02-28T06:15:44Z Re: trying to convert row to column https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581897#M216135 <HTML><HEAD></HEAD><BODY><P>When I am using crosstable,&nbsp; column2 also comes under company codes...</P><P>but I want column2 as a saperate column..</P></BODY></HTML> Fri, 28 Feb 2014 06:19:17 GMT https://community.qlik.com/t5/QlikView/trying-to-convert-row-to-column/m-p/581897#M216135 2014-02-28T06:19:17Z