topic Column to Row in qlikview in QlikView https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116897#M630705 <HTML><HEAD></HEAD><BODY><P>Hi , I got a requirement that i have shuffle column as row.&nbsp; below is the requirement</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Stock</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Itemtype</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sale</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>InStock</STRONG></TH></TR><TR><TD style="padding: 2px;">Store1</TD><TD style="padding: 2px;">I1</TD><TD style="padding: 2px;">Product1</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">Store1</TD><TD style="padding: 2px;">I2</TD><TD style="padding: 2px;">Product2</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">Store2</TD><TD style="padding: 2px;">I1</TD><TD style="padding: 2px;">Product1</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">Store2</TD><TD style="padding: 2px;">I3</TD><TD style="padding: 2px;">Product2</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P></P><P>AS</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item Type</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stock</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Store1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store2</STRONG></TH></TR><TR><TD style="padding: 2px;">I1</TD><TD style="padding: 2px;"><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TD style="padding: 2px;">Product1</TD></TR></TBODY></TABLE></TD><TD style="padding: 2px;">Sale</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Product2</TD><TD style="padding: 2px;">InStock</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">I2</TD><TD style="padding: 2px;"><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TD style="padding: 2px;">Product1</TD></TR></TBODY></TABLE></TD><TD style="padding: 2px;">Sale</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Product2</TD><TD style="padding: 2px;">InStock</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P></P><P>I will look forward to appreciate your answer</P></BODY></HTML> Wed, 03 Aug 2016 01:56:58 GMT 2016-08-03T01:56:58Z Column to Row in qlikview https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116897#M630705 <HTML><HEAD></HEAD><BODY><P>Hi , I got a requirement that i have shuffle column as row.&nbsp; below is the requirement</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Stock</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Itemtype</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sale</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>InStock</STRONG></TH></TR><TR><TD style="padding: 2px;">Store1</TD><TD style="padding: 2px;">I1</TD><TD style="padding: 2px;">Product1</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">Store1</TD><TD style="padding: 2px;">I2</TD><TD style="padding: 2px;">Product2</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">Store2</TD><TD style="padding: 2px;">I1</TD><TD style="padding: 2px;">Product1</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">Store2</TD><TD style="padding: 2px;">I3</TD><TD style="padding: 2px;">Product2</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P></P><P>AS</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item Type</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stock</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Store1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store2</STRONG></TH></TR><TR><TD style="padding: 2px;">I1</TD><TD style="padding: 2px;"><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TD style="padding: 2px;">Product1</TD></TR></TBODY></TABLE></TD><TD style="padding: 2px;">Sale</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Product2</TD><TD style="padding: 2px;">InStock</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">I2</TD><TD style="padding: 2px;"><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TD style="padding: 2px;">Product1</TD></TR></TBODY></TABLE></TD><TD style="padding: 2px;">Sale</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Product2</TD><TD style="padding: 2px;">InStock</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P></P><P>I will look forward to appreciate your answer</P></BODY></HTML> Wed, 03 Aug 2016 01:56:58 GMT https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116897#M630705 2016-08-03T01:56:58Z Re: Column to Row in qlikview https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116898#M630706 <HTML><HEAD></HEAD><BODY><P>Can you not simply deploy as a pivot table in the front end?</P></BODY></HTML> Wed, 03 Aug 2016 14:41:23 GMT https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116898#M630706 adamdavi3s 2016-08-03T14:41:23Z Re: Column to Row in qlikview https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116899#M630707 <HTML><HEAD></HEAD><BODY><P>Please try this</P><P>tab1:</P><P>CrossTable(salesinstack, value, 3)</P><P>&nbsp; LOAD Stock,</P><P>&nbsp;&nbsp;&nbsp; Item,</P><P>&nbsp;&nbsp;&nbsp; itemtype,</P><P>&nbsp;&nbsp;&nbsp; Sale, </P><P>&nbsp;&nbsp;&nbsp; instock</P><P>FROM</P><P><C></C></P><P>(ooxml, embedded labels, table is Sheet1);</P><P></P><P></P><P></P><P>Tab2:</P><P>generic Load Item,</P><P>Stock,value Resident tab1;</P></BODY></HTML> Wed, 03 Aug 2016 14:56:43 GMT https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116899#M630707 2016-08-03T14:56:43Z Re: Column to Row in qlikview https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116900#M630708 <HTML><HEAD></HEAD><BODY><P>or you can use crosstable</P><P></P><P>beck</P></BODY></HTML> Wed, 03 Aug 2016 14:57:59 GMT https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116900#M630708 beck_bakytbek 2016-08-03T14:57:59Z Re: Column to Row in qlikview https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116901#M630709 <HTML><HEAD></HEAD><BODY><P>Yes Adam, I have already done with the requirement but forgot to close the thread. Thank you </P></BODY></HTML> Wed, 03 Aug 2016 14:59:26 GMT https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116901#M630709 2016-08-03T14:59:26Z Re: Column to Row in qlikview https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116902#M630710 <HTML><HEAD></HEAD><BODY><P>pivot table :dimentions are item,itemtype,salesinstack,store1,store2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression:Sum(item)</P><P></P><P></P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><P><SPAN style="color: #363636;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #363636;"><STRONG>Item</STRONG></SPAN><STRONG> </STRONG></P></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>itemtype</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>salesinstack</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>store1</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>store2</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sum(Item)</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">11</SPAN></TD><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">product1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">instock</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">22</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sale</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">22</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">12</SPAN></TD><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">instock</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">Sale</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">-</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">13</SPAN></TD><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">instock</SPAN></TD><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">-</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">Sale</SPAN></TD><TD bgcolor="#ffffff" rowspan="2"><SPAN style="color: #363636;">-</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>itemtype</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>store1</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>store2</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Item</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>salesinstack</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">instock</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sale</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">instock</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sale</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">instock</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sale</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">instock</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sale</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">instock</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">product2</SPAN></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Sale</SPAN></TD></TR></TBODY></TABLE><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please try this</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">under transformation wizard select crosstable ,set qualifier field is 3,Attribute field is salesinstack and Data field is Value.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">tab1:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CrossTable(salesinstack, value, 3)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp; LOAD Stock,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Item,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; itemtype,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; Sale,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp; instock</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><C></C></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(ooxml, embedded labels, table is Sheet1);</P><P></P><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Tab2:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">generic Load Item,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Stock,value Resident tab1;</P></BODY></HTML> Wed, 03 Aug 2016 15:04:27 GMT https://community.qlik.com/t5/QlikView/Column-to-Row-in-qlikview/m-p/1116902#M630710 2016-08-03T15:04:27Z