topic Re: crosstable issue... in QlikView https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/476298#M177883 <HTML><HEAD></HEAD><BODY><P>ResultTable:</P><P>Crosstable(Product,value,2)</P><P>Load * from <EM>...somewhere...</EM>;</P></BODY></HTML> Thu, 08 Aug 2013 10:28:12 GMT Gysbert_Wassenaar 2013-08-08T10:28:12Z crosstable issue... https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/476297#M177882 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a data which i need to transform it in to new format using crosstable.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="506"><TBODY><TR><TD height="20" width="157">date_time</TD><TD width="157">Total</TD><TD width="64">AC</TD><TD width="64">Tubelight</TD><TD width="64">Computer</TD></TR><TR><TD align="right" class="xl63" height="20">8/8/2013 12:15</TD><TD align="right">67</TD><TD align="right">25</TD><TD align="right">30</TD><TD align="right">12</TD></TR><TR><TD align="right" class="xl63" height="20">8/9/2013 1:20</TD><TD align="right">128</TD><TD align="right">50</TD><TD align="right">54</TD><TD align="right">24</TD></TR><TR><TD align="right" class="xl63" height="20">8/10/2013 2:17</TD><TD align="right">202</TD><TD align="right">60</TD><TD align="right">55</TD><TD align="right">87</TD></TR><TR><TD align="right" class="xl63" height="20">8/11/2013 21:30</TD><TD align="right">97</TD><TD align="right">65</TD><TD align="right">22</TD><TD align="right">10</TD></TR></TBODY></TABLE><P><BR />Now i want to convert this data in below format,</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="442"><TBODY><TR><TD height="20" width="157">date_time</TD><TD width="157">Total</TD><TD width="64">Product</TD><TD width="64">value</TD></TR><TR><TD align="right" class="xl65" height="20">8/8/2013 12:15</TD><TD align="right">67</TD><TD>AC</TD><TD align="right">25</TD></TR><TR><TD align="right" class="xl65" height="20">8/8/2013 12:15</TD><TD align="right">67</TD><TD>Tubelight</TD><TD align="right">30</TD></TR><TR><TD align="right" class="xl65" height="20">8/8/2013 12:15</TD><TD align="right">67</TD><TD>Computer</TD><TD align="right">12</TD></TR><TR><TD align="right" class="xl65" height="20">8/9/2013 1:20</TD><TD align="right">128</TD><TD>AC</TD><TD align="right">50</TD></TR><TR><TD align="right" class="xl65" height="20">8/9/2013 1:20</TD><TD align="right">128</TD><TD>Tubelight</TD><TD align="right">54</TD></TR><TR><TD align="right" class="xl65" height="20">8/9/2013 1:20</TD><TD align="right">128</TD><TD>Computer</TD><TD align="right">24</TD></TR><TR><TD align="right" class="xl65" height="20">8/10/2013 2:17</TD><TD align="right">202</TD><TD>AC</TD><TD align="right">60</TD></TR><TR><TD align="right" class="xl65" height="20">8/10/2013 2:17</TD><TD align="right">202</TD><TD>Tubelight</TD><TD align="right">55</TD></TR><TR><TD align="right" class="xl65" height="20">8/10/2013 2:17</TD><TD align="right">202</TD><TD>Computer</TD><TD align="right">87</TD></TR><TR><TD align="right" class="xl65" height="20">8/11/2013 21:30</TD><TD align="right">97</TD><TD>AC</TD><TD align="right">65</TD></TR><TR><TD align="right" class="xl65" height="20">8/11/2013 21:30</TD><TD align="right">97</TD><TD>Tubelight</TD><TD align="right">22</TD></TR><TR><TD align="right" class="xl65" height="20">8/11/2013 21:30</TD><TD align="right">97</TD><TD>Computer</TD><TD align="right">10</TD></TR></TBODY></TABLE><P><BR />please guide.</P><P></P><P>thanks,<BR />hitesh</P></BODY></HTML> Thu, 08 Aug 2013 10:25:59 GMT https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/476297#M177882 2013-08-08T10:25:59Z Re: crosstable issue... https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/476298#M177883 <HTML><HEAD></HEAD><BODY><P>ResultTable:</P><P>Crosstable(Product,value,2)</P><P>Load * from <EM>...somewhere...</EM>;</P></BODY></HTML> Thu, 08 Aug 2013 10:28:12 GMT https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/476298#M177883 Gysbert_Wassenaar 2013-08-08T10:28:12Z Re: crosstable issue... https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/476299#M177884 <HTML><HEAD></HEAD><BODY><P>thanks a lot gysbert.</P></BODY></HTML> Thu, 08 Aug 2013 11:06:42 GMT https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/476299#M177884 2013-08-08T11:06:42Z