topic Transpose rows into columns in QlikView https://community.qlik.com/t5/QlikView/Transpose-rows-into-columns/m-p/734380#M262942 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P></P><P>I have this table.</P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 358px; height: 161px;" width="356"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Project</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Work</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Price 2014</STRONG></TH></TR><TR><TD style="padding: 2px;">Project_1</TD><TD style="padding: 2px;">Documentation</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">Project_1</TD><TD style="padding: 2px;">Constraction</TD><TD style="padding: 2px;">2000</TD></TR><TR><TD colspan="1">Project_1</TD><TD colspan="1">End</TD><TD colspan="1">3000</TD></TR><TR><TD style="padding: 2px;">Project_2</TD><TD style="padding: 2px;">Documentation</TD><TD style="padding: 2px;">1500</TD></TR><TR><TD style="padding: 2px;">Project_2</TD><TD style="padding: 2px;">Constraction</TD><TD style="padding: 2px;">2500</TD></TR><TR><TD>Project_2</TD><TD>End</TD><TD>3000</TD></TR></TBODY></TABLE><P></P><P>How I can create this table?</P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid #000000; width: 356px; height: 60px;" width="354"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Project</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Documentation</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Constraction</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">End</TH></TR><TR><TD style="padding: 2px;">Project_1</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">3000</TD></TR><TR><TD style="padding: 2px;">Project_2</TD><TD style="padding: 2px;">1500</TD><TD style="padding: 2px;">2500</TD><TD style="padding: 2px;">3000</TD></TR></TBODY></TABLE><P></P><P>I must use crosstable?</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 24 Jun 2014 09:59:56 GMT 2014-06-24T09:59:56Z Transpose rows into columns https://community.qlik.com/t5/QlikView/Transpose-rows-into-columns/m-p/734380#M262942 <HTML><HEAD></HEAD><BODY><P>Hi all.</P><P></P><P>I have this table.</P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 358px; height: 161px;" width="356"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Project</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Work</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Price 2014</STRONG></TH></TR><TR><TD style="padding: 2px;">Project_1</TD><TD style="padding: 2px;">Documentation</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">Project_1</TD><TD style="padding: 2px;">Constraction</TD><TD style="padding: 2px;">2000</TD></TR><TR><TD colspan="1">Project_1</TD><TD colspan="1">End</TD><TD colspan="1">3000</TD></TR><TR><TD style="padding: 2px;">Project_2</TD><TD style="padding: 2px;">Documentation</TD><TD style="padding: 2px;">1500</TD></TR><TR><TD style="padding: 2px;">Project_2</TD><TD style="padding: 2px;">Constraction</TD><TD style="padding: 2px;">2500</TD></TR><TR><TD>Project_2</TD><TD>End</TD><TD>3000</TD></TR></TBODY></TABLE><P></P><P>How I can create this table?</P><TABLE border="1" class="jiveBorder" height="74" style="border: 1px solid #000000; width: 356px; height: 60px;" width="354"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; text-align: center;">Project</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Documentation</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Constraction</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">End</TH></TR><TR><TD style="padding: 2px;">Project_1</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">2000</TD><TD style="padding: 2px;">3000</TD></TR><TR><TD style="padding: 2px;">Project_2</TD><TD style="padding: 2px;">1500</TD><TD style="padding: 2px;">2500</TD><TD style="padding: 2px;">3000</TD></TR></TBODY></TABLE><P></P><P>I must use crosstable?</P><P></P><P>Thank you.</P></BODY></HTML> Tue, 24 Jun 2014 09:59:56 GMT https://community.qlik.com/t5/QlikView/Transpose-rows-into-columns/m-p/734380#M262942 2014-06-24T09:59:56Z Re: Transpose rows into columns https://community.qlik.com/t5/QlikView/Transpose-rows-into-columns/m-p/734381#M262943 <HTML><HEAD></HEAD><BODY><P>No, the opposite: a generic load.</P><P></P><P>Generic</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Project, Work, Price 2014</P><P>&nbsp;&nbsp;&nbsp; Project_1, Documentation, 1000</P><P>&nbsp;&nbsp;&nbsp; Project_1, Constraction, 2000</P><P>&nbsp;&nbsp;&nbsp; Project_1, End, 3000</P><P>&nbsp;&nbsp;&nbsp; Project_2, Documentation, 1500</P><P>&nbsp;&nbsp;&nbsp; Project_2, Constraction, 2500</P><P>&nbsp;&nbsp;&nbsp; Project_2, End, 3000</P><P>];</P><P></P><P>See attached qvw</P></BODY></HTML> Tue, 24 Jun 2014 10:04:20 GMT https://community.qlik.com/t5/QlikView/Transpose-rows-into-columns/m-p/734381#M262943 Gysbert_Wassenaar 2014-06-24T10:04:20Z Re: Transpose rows into columns https://community.qlik.com/t5/QlikView/Transpose-rows-into-columns/m-p/734382#M262944 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Tue, 24 Jun 2014 11:22:13 GMT https://community.qlik.com/t5/QlikView/Transpose-rows-into-columns/m-p/734382#M262944 2014-06-24T11:22:13Z