topic Help please in QlikView https://community.qlik.com/t5/QlikView/Help-please/m-p/489303#M182859 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Need help with an aggregation expression. I have the current kind of table with 100000 of rows. The end result should be a grid chart with y- and x-axis as category dimensions and data points as categories with sum of employee id's which are present in both</P><P>categories.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 216px;"><TBODY><TR><TD height="15" width="72">id</TD><TD width="72">Category</TD><TD width="72">Hits</TD></TR><TR></TR><TR><TD align="right" height="14">1234</TD><TD>Category 1</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">12345</TD><TD>Category 1</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">4321</TD><TD>Category 3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">432</TD><TD>Category 2</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">432</TD><TD>Category 3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">432</TD><TD>Category 1</TD><TD align="right">1</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 16 Dec 2013 12:54:34 GMT 2013-12-16T12:54:34Z Help please https://community.qlik.com/t5/QlikView/Help-please/m-p/489303#M182859 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Need help with an aggregation expression. I have the current kind of table with 100000 of rows. The end result should be a grid chart with y- and x-axis as category dimensions and data points as categories with sum of employee id's which are present in both</P><P>categories.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 216px;"><TBODY><TR><TD height="15" width="72">id</TD><TD width="72">Category</TD><TD width="72">Hits</TD></TR><TR></TR><TR><TD align="right" height="14">1234</TD><TD>Category 1</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">12345</TD><TD>Category 1</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">4321</TD><TD>Category 3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">432</TD><TD>Category 2</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">432</TD><TD>Category 3</TD><TD align="right">1</TD></TR><TR><TD align="right" height="15">432</TD><TD>Category 1</TD><TD align="right">1</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 16 Dec 2013 12:54:34 GMT https://community.qlik.com/t5/QlikView/Help-please/m-p/489303#M182859 2013-12-16T12:54:34Z