topic Re: Strange transpose - help needed :) in QlikView https://community.qlik.com/t5/QlikView/Strange-transpose-help-needed/m-p/785996#M278050 <HTML><HEAD></HEAD><BODY><P>Oh, that was easy (as always)! Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 14 Jan 2015 09:02:32 GMT 2015-01-14T09:02:32Z Strange transpose - help needed :) https://community.qlik.com/t5/QlikView/Strange-transpose-help-needed/m-p/785994#M278048 <HTML><HEAD></HEAD><BODY><P>Hi all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I have a table that looks like this:</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>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 5</STRONG></TH></TR><TR><TD style="padding: 2px;">Data 1</TD><TD style="padding: 2px;">Data 21</TD><TD style="padding: 2px;">Data 31</TD><TD style="padding: 2px;">Data 41</TD><TD style="padding: 2px;">Data 51</TD></TR><TR><TD style="padding: 2px;">Data 2</TD><TD style="padding: 2px;">Data 22</TD><TD style="padding: 2px;">Data 32</TD><TD style="padding: 2px;">Data 42</TD><TD style="padding: 2px;">Data 52</TD></TR><TR><TD style="padding: 2px;">Data 3</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Data 33</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Data 53</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Data 34</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Data 54</TD></TR></TBODY></TABLE><P></P><P>My goal is to create a table that looks like this:</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>MainProcess</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Activity</STRONG></TH></TR><TR><TD style="padding: 2px;">Header 1</TD><TD style="padding: 2px;">Data 1</TD></TR><TR><TD style="padding: 2px;">Header 1</TD><TD style="padding: 2px;">Data 2</TD></TR><TR><TD style="padding: 2px;">Header 1</TD><TD style="padding: 2px;">Data 3</TD></TR><TR><TD style="padding: 2px;">Header 2</TD><TD style="padding: 2px;">Data 21</TD></TR><TR><TD style="padding: 2px;">Header 2</TD><TD style="padding: 2px;">Data 22</TD></TR><TR><TD style="padding: 2px;">Header 3</TD><TD style="padding: 2px;">Data 31</TD></TR><TR><TD style="padding: 2px;">Header 3</TD><TD style="padding: 2px;">Data 32 </TD></TR><TR><TD style="padding: 2px;">Header 3</TD><TD style="padding: 2px;">Data 33</TD></TR><TR><TD style="padding: 2px;">Header 3</TD><TD style="padding: 2px;">Data 34</TD></TR><TR><TD style="padding: 2px;">And so on....</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Any advice would be much appriciated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards</P><P>Trond Erik</P></BODY></HTML> Wed, 14 Jan 2015 08:32:52 GMT https://community.qlik.com/t5/QlikView/Strange-transpose-help-needed/m-p/785994#M278048 2015-01-14T08:32:52Z Re: Strange transpose - help needed :) https://community.qlik.com/t5/QlikView/Strange-transpose-help-needed/m-p/785995#M278049 <HTML><HEAD></HEAD><BODY><P>Not so strange. Just use the CrossTable function. See attached qvw.</P></BODY></HTML> Wed, 14 Jan 2015 08:59:27 GMT https://community.qlik.com/t5/QlikView/Strange-transpose-help-needed/m-p/785995#M278049 Gysbert_Wassenaar 2015-01-14T08:59:27Z Re: Strange transpose - help needed :) https://community.qlik.com/t5/QlikView/Strange-transpose-help-needed/m-p/785996#M278050 <HTML><HEAD></HEAD><BODY><P>Oh, that was easy (as always)! Thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 14 Jan 2015 09:02:32 GMT https://community.qlik.com/t5/QlikView/Strange-transpose-help-needed/m-p/785996#M278050 2015-01-14T09:02:32Z