topic Conversion of table layout in QlikView https://community.qlik.com/t5/QlikView/Conversion-of-table-layout/m-p/301071#M1180814 <HTML><HEAD></HEAD><BODY><P>I have the following table layout:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Article</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>20110110<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>20110117</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>20110120</STRONG></SPAN></TH></TR><TR><TD>Icecream</TD><TD>15</TD><TD>0</TD><TD>32</TD></TR><TR><TD>Hotdog</TD><TD>2</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P></P><P></P><P>And I would like to convert it into the following layout:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border-width: 1px; border-color: #000000; border-style: solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Article</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Date<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Volume<BR /></STRONG></TH></TR><TR><TD>Icecream</TD><TD>20110110</TD><TD>15</TD></TR><TR><TD>Icecream</TD><TD>20110120</TD><TD>32</TD></TR><TR><TD>Hotdog</TD><TD>20110110</TD><TD>2</TD></TR></TBODY></TABLE><P></P><P></P><P>I have thousands of lines so i need som kind of automated algorithm to do this.</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 21 Feb 2012 03:16:16 GMT 2012-02-21T03:16:16Z Conversion of table layout https://community.qlik.com/t5/QlikView/Conversion-of-table-layout/m-p/301071#M1180814 <HTML><HEAD></HEAD><BODY><P>I have the following table layout:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Article</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>20110110<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>20110117</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>20110120</STRONG></SPAN></TH></TR><TR><TD>Icecream</TD><TD>15</TD><TD>0</TD><TD>32</TD></TR><TR><TD>Hotdog</TD><TD>2</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P></P><P></P><P>And I would like to convert it into the following layout:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border-width: 1px; border-color: #000000; border-style: solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Article</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Date<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Volume<BR /></STRONG></TH></TR><TR><TD>Icecream</TD><TD>20110110</TD><TD>15</TD></TR><TR><TD>Icecream</TD><TD>20110120</TD><TD>32</TD></TR><TR><TD>Hotdog</TD><TD>20110110</TD><TD>2</TD></TR></TBODY></TABLE><P></P><P></P><P>I have thousands of lines so i need som kind of automated algorithm to do this.</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 21 Feb 2012 03:16:16 GMT https://community.qlik.com/t5/QlikView/Conversion-of-table-layout/m-p/301071#M1180814 2012-02-21T03:16:16Z Conversion of table layout https://community.qlik.com/t5/QlikView/Conversion-of-table-layout/m-p/301072#M1180815 <HTML><HEAD></HEAD><BODY><P>Solved it by myself through using the crosstable function in the load script, thanks anyway!</P></BODY></HTML> Tue, 21 Feb 2012 04:01:38 GMT https://community.qlik.com/t5/QlikView/Conversion-of-table-layout/m-p/301072#M1180815 2012-02-21T04:01:38Z