topic Cross table in QlikView https://community.qlik.com/t5/QlikView/Cross-table/m-p/216925#M70189 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" width="240"><TBODY><TR><TD valign="bottom" width="80"><P>X</P></TD><TD valign="bottom" width="80"><P>Y</P></TD><TD valign="bottom" width="80"><P>Z</P></TD></TR><TR><TD valign="bottom" width="80"><P>x3</P></TD><TD valign="bottom" width="80"><P>y2</P></TD><TD valign="bottom" width="80"><P>z3</P></TD></TR><TR><TD valign="bottom" width="80"><P>x1</P></TD><TD valign="bottom" width="80"><P>y2</P></TD><TD valign="bottom" width="80"><P>z4</P></TD></TR><TR><TD valign="bottom" width="80"><P>x1</P></TD><TD valign="bottom" width="80"><P>y2</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR><TR><TD valign="bottom" width="80"><P>x4</P></TD><TD valign="bottom" width="80"><P>y1</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR><TR><TD valign="bottom" width="80"><P>x2</P></TD><TD valign="bottom" width="80"><P>y4</P></TD><TD valign="bottom" width="80"><P>z3</P></TD></TR><TR><TD valign="bottom" width="80"><P>x3</P></TD><TD valign="bottom" width="80"><P>y4</P></TD><TD valign="bottom" width="80"><P>z2</P></TD></TR><TR><TD valign="bottom" width="80"><P>x2</P></TD><TD valign="bottom" width="80"><P>y3</P></TD><TD valign="bottom" width="80"><P>z2</P></TD></TR><TR><TD valign="bottom" width="80"><P>x3</P></TD><TD valign="bottom" width="80"><P>y2</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR><TR><TD valign="bottom" width="80"><P>x3</P></TD><TD valign="bottom" width="80"><P>y4</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR><TR><TD valign="bottom" width="80"><P>x1</P></TD><TD valign="bottom" width="80"><P>y3</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P></P><P>I need to get the following table knowing that :</P><P>- the cell (x,1)=3 contain how many "x1" in the column "X" (in the first table)</P><P>- the cell (y,2)=4 contain how many "y2" in the column "Y" (in the first table)</P><P>- and so on</P><BR /><BR /> <P></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" width="400"><TBODY><TR><TD valign="bottom" width="80"><P style="text-align: center"></P></TD><TD valign="bottom" width="80"><P style="text-align: center">1</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">3</P></TD><TD valign="bottom" width="80"><P style="text-align: center">4</P></TD></TR><TR><TD valign="bottom" width="80"><P style="text-align: center">x</P></TD><TD valign="bottom" width="80"><P style="text-align: center">3</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">4</P></TD><TD valign="bottom" width="80"><P style="text-align: center">1</P></TD></TR><TR><TD valign="bottom" width="80"><P style="text-align: center">y</P></TD><TD valign="bottom" width="80"><P style="text-align: center">1</P></TD><TD valign="bottom" width="80"><P style="text-align: center">4</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">3</P></TD></TR><TR><TD valign="bottom" width="80"><P style="text-align: center">z</P></TD><TD valign="bottom" width="80"><P style="text-align: center">5</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">1</P></TD></TR></TBODY></TABLE><BR /><BR /> <P>Regards,</P><P>Yacine</P></BODY></HTML> Tue, 15 Feb 2011 15:21:58 GMT yacine_b 2011-02-15T15:21:58Z Cross table https://community.qlik.com/t5/QlikView/Cross-table/m-p/216925#M70189 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have the following table:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" width="240"><TBODY><TR><TD valign="bottom" width="80"><P>X</P></TD><TD valign="bottom" width="80"><P>Y</P></TD><TD valign="bottom" width="80"><P>Z</P></TD></TR><TR><TD valign="bottom" width="80"><P>x3</P></TD><TD valign="bottom" width="80"><P>y2</P></TD><TD valign="bottom" width="80"><P>z3</P></TD></TR><TR><TD valign="bottom" width="80"><P>x1</P></TD><TD valign="bottom" width="80"><P>y2</P></TD><TD valign="bottom" width="80"><P>z4</P></TD></TR><TR><TD valign="bottom" width="80"><P>x1</P></TD><TD valign="bottom" width="80"><P>y2</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR><TR><TD valign="bottom" width="80"><P>x4</P></TD><TD valign="bottom" width="80"><P>y1</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR><TR><TD valign="bottom" width="80"><P>x2</P></TD><TD valign="bottom" width="80"><P>y4</P></TD><TD valign="bottom" width="80"><P>z3</P></TD></TR><TR><TD valign="bottom" width="80"><P>x3</P></TD><TD valign="bottom" width="80"><P>y4</P></TD><TD valign="bottom" width="80"><P>z2</P></TD></TR><TR><TD valign="bottom" width="80"><P>x2</P></TD><TD valign="bottom" width="80"><P>y3</P></TD><TD valign="bottom" width="80"><P>z2</P></TD></TR><TR><TD valign="bottom" width="80"><P>x3</P></TD><TD valign="bottom" width="80"><P>y2</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR><TR><TD valign="bottom" width="80"><P>x3</P></TD><TD valign="bottom" width="80"><P>y4</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR><TR><TD valign="bottom" width="80"><P>x1</P></TD><TD valign="bottom" width="80"><P>y3</P></TD><TD valign="bottom" width="80"><P>z1</P></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P></P><P>I need to get the following table knowing that :</P><P>- the cell (x,1)=3 contain how many "x1" in the column "X" (in the first table)</P><P>- the cell (y,2)=4 contain how many "y2" in the column "Y" (in the first table)</P><P>- and so on</P><BR /><BR /> <P></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" width="400"><TBODY><TR><TD valign="bottom" width="80"><P style="text-align: center"></P></TD><TD valign="bottom" width="80"><P style="text-align: center">1</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">3</P></TD><TD valign="bottom" width="80"><P style="text-align: center">4</P></TD></TR><TR><TD valign="bottom" width="80"><P style="text-align: center">x</P></TD><TD valign="bottom" width="80"><P style="text-align: center">3</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">4</P></TD><TD valign="bottom" width="80"><P style="text-align: center">1</P></TD></TR><TR><TD valign="bottom" width="80"><P style="text-align: center">y</P></TD><TD valign="bottom" width="80"><P style="text-align: center">1</P></TD><TD valign="bottom" width="80"><P style="text-align: center">4</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">3</P></TD></TR><TR><TD valign="bottom" width="80"><P style="text-align: center">z</P></TD><TD valign="bottom" width="80"><P style="text-align: center">5</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">2</P></TD><TD valign="bottom" width="80"><P style="text-align: center">1</P></TD></TR></TBODY></TABLE><BR /><BR /> <P>Regards,</P><P>Yacine</P></BODY></HTML> Tue, 15 Feb 2011 15:21:58 GMT https://community.qlik.com/t5/QlikView/Cross-table/m-p/216925#M70189 yacine_b 2011-02-15T15:21:58Z