topic Cross Table Help in App Development https://community.qlik.com/t5/App-Development/Cross-Table-Help/m-p/128363#M9001 <HTML><HEAD></HEAD><BODY><P>Hi All I have the below table.&nbsp; The columns '5555','6666','7777' are ParentID's and their values are ownership percentages of the ChildID in column 1</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>ChildID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Description</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MonthEnd</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">5555</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">6666</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">7777</TH></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Jan18</TD><TD style="padding: 2px;">.333</TD><TD style="padding: 2px;">.333</TD><TD style="padding: 2px;">.333</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Feb18</TD><TD style="padding: 2px;">.5</TD><TD style="padding: 2px;">.25</TD><TD style="padding: 2px;">.25</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">March18</TD><TD style="padding: 2px;">.5</TD><TD style="padding: 2px;">.5</TD><TD style="padding: 2px;">0</TD></TR></TBODY></TABLE><P></P><P></P><P>I'd like to use the cross table function to create the below table does anyone have any ideas?</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>ChildID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Description</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">MonthEnd</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ParentID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Ownership %</TH></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Jan18</TD><TD style="padding: 2px;">5555</TD><TD style="padding: 2px;">.333</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Jan18</TD><TD style="padding: 2px;">6666</TD><TD style="padding: 2px;">.333</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Jan18</TD><TD style="padding: 2px;">7777</TD><TD style="padding: 2px;"><P>.333</P></TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Feb18</TD><TD style="padding: 2px;">5555</TD><TD style="padding: 2px;">.5</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Feb18</TD><TD style="padding: 2px;">6666</TD><TD style="padding: 2px;">.25</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Feb18</TD><TD style="padding: 2px;">7777</TD><TD style="padding: 2px;">.25</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">March18</TD><TD style="padding: 2px;">5555</TD><TD style="padding: 2px;">.5</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">March18</TD><TD style="padding: 2px;">6666</TD><TD style="padding: 2px;">.5</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">March18</TD><TD style="padding: 2px;">7777</TD><TD style="padding: 2px;">0</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 28 Aug 2018 13:02:37 GMT m_perreault 2018-08-28T13:02:37Z Cross Table Help https://community.qlik.com/t5/App-Development/Cross-Table-Help/m-p/128363#M9001 <HTML><HEAD></HEAD><BODY><P>Hi All I have the below table.&nbsp; The columns '5555','6666','7777' are ParentID's and their values are ownership percentages of the ChildID in column 1</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>ChildID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Description</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>MonthEnd</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">5555</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">6666</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">7777</TH></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Jan18</TD><TD style="padding: 2px;">.333</TD><TD style="padding: 2px;">.333</TD><TD style="padding: 2px;">.333</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Feb18</TD><TD style="padding: 2px;">.5</TD><TD style="padding: 2px;">.25</TD><TD style="padding: 2px;">.25</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">March18</TD><TD style="padding: 2px;">.5</TD><TD style="padding: 2px;">.5</TD><TD style="padding: 2px;">0</TD></TR></TBODY></TABLE><P></P><P></P><P>I'd like to use the cross table function to create the below table does anyone have any ideas?</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>ChildID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Description</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">MonthEnd</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ParentID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Ownership %</TH></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Jan18</TD><TD style="padding: 2px;">5555</TD><TD style="padding: 2px;">.333</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Jan18</TD><TD style="padding: 2px;">6666</TD><TD style="padding: 2px;">.333</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Jan18</TD><TD style="padding: 2px;">7777</TD><TD style="padding: 2px;"><P>.333</P></TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Feb18</TD><TD style="padding: 2px;">5555</TD><TD style="padding: 2px;">.5</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Feb18</TD><TD style="padding: 2px;">6666</TD><TD style="padding: 2px;">.25</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">Feb18</TD><TD style="padding: 2px;">7777</TD><TD style="padding: 2px;">.25</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">March18</TD><TD style="padding: 2px;">5555</TD><TD style="padding: 2px;">.5</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">March18</TD><TD style="padding: 2px;">6666</TD><TD style="padding: 2px;">.5</TD></TR><TR><TD style="padding: 2px;">5005</TD><TD style="padding: 2px;">ABC Company</TD><TD style="padding: 2px;">March18</TD><TD style="padding: 2px;">7777</TD><TD style="padding: 2px;">0</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 28 Aug 2018 13:02:37 GMT https://community.qlik.com/t5/App-Development/Cross-Table-Help/m-p/128363#M9001 m_perreault 2018-08-28T13:02:37Z Re: Cross Table Help https://community.qlik.com/t5/App-Development/Cross-Table-Help/m-p/128364#M9002 <HTML><HEAD></HEAD><BODY><P>It was simpler than I realized</P><P></P><P>CrossTable([Parent ID],Ownership,3)</P><P>Load *</P><P>From MyTable</P></BODY></HTML> Tue, 28 Aug 2018 13:12:18 GMT https://community.qlik.com/t5/App-Development/Cross-Table-Help/m-p/128364#M9002 m_perreault 2018-08-28T13:12:18Z