topic Re: Cross Table in QlikView https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726731#M1059241 <HTML><HEAD></HEAD><BODY><P>I am waiting for reply.......</P></BODY></HTML> Wed, 15 Oct 2014 03:48:36 GMT Anonymous 2014-10-15T03:48:36Z Cross Table https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726729#M1059239 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have one excel file called as cross table. </SPAN><STRONG><EM style="text-decoration: underline;"><BR /></EM></STRONG></P><P><STRONG><EM style="text-decoration: underline;"><BR /></EM></STRONG></P><P><STRONG><EM style="text-decoration: underline;">Current Data Source:</EM></STRONG></P><P>From the excel source, with the below structure,</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="626"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="23"><P><STRONG style="color: #333333; font-size: 8.0pt;"> </STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="67"><P><STRONG style="color: #333333; font-size: 8.0pt;">School_Year</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="35"><P><STRONG style="color: #333333; font-size: 8.0pt;"> </STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="45"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2003</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="43"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2004</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="36"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2005</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="36"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2006</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="36"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2007</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="36"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2008</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="36"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2009</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="36"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2010</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="36"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2011</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="27"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2012</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="27"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2013</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="27"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2014</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="27"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2015</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="27"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2016</STRONG></P></TD><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="27"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">2017</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="23"><P><STRONG style="color: #333333; font-size: 8.0pt;">ID</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="67"><P><STRONG style="color: #333333; font-size: 8.0pt;">StudentName</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="35"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Comments</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="25"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="20"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="24"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="19"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="20"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="16"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="20"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="16"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="20"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="16"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="20"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="16"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="20"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="16"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="20"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="16"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="20"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="16"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="15"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="12"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="15"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="12"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="15"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="12"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="15"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="12"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="15"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="12"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="15"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">School</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #D9D9D9; padding: 0 5.4pt 0 5.4pt;" width="12"><P align="center" style="text-align: center;"><STRONG style="color: #333333; font-size: 8.0pt;">Level</STRONG></P></TD></TR></TBODY></TABLE><P></P><P><STRONG><EM style="text-decoration: underline;">QlikView Chart Expectation:</EM></STRONG></P><P>I want the output&nbsp; as attached image.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 15 Oct 2014 02:36:33 GMT https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726729#M1059239 Anonymous 2014-10-15T02:36:33Z Re: Cross Table https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726730#M1059240 <HTML><HEAD></HEAD><BODY><P>using cross table step I want above output.</P></BODY></HTML> Wed, 15 Oct 2014 02:37:56 GMT https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726730#M1059240 Anonymous 2014-10-15T02:37:56Z Re: Cross Table https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726731#M1059241 <HTML><HEAD></HEAD><BODY><P>I am waiting for reply.......</P></BODY></HTML> Wed, 15 Oct 2014 03:48:36 GMT https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726731#M1059241 Anonymous 2014-10-15T03:48:36Z Re: Cross Table https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726732#M1059242 <HTML><HEAD></HEAD><BODY><P>Maybe closing some of your threads could help you get answers for new ones.</P><P></P><P>Regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 21 Oct 2014 19:46:28 GMT https://community.qlik.com/t5/QlikView/Cross-Table/m-p/726732#M1059242 MarcoWedel 2014-10-21T19:46:28Z