topic Aggregation in QlikView https://community.qlik.com/t5/QlikView/Aggregation/m-p/784667#M664691 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P> <BR />I got a difficult issue like below. Please help me on it.</P><P> <BR /> <BR /> <BR />Summary reporting where we need to identify any records having same Parent ID and with the same CSA ID, in this case we pick the longest CRISP Parent Full Name and only display one record with their aggregate P0 - P15</P><P> <BR /> <BR /> <BR /> <BR /> <BR />Example as I attached.</P><P> <BR /> <BR /> <BR /> <BR /> <BR />Thank you.</P></BODY></HTML> Wed, 11 Feb 2015 10:50:24 GMT priyarane 2015-02-11T10:50:24Z Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/784667#M664691 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P> <BR />I got a difficult issue like below. Please help me on it.</P><P> <BR /> <BR /> <BR />Summary reporting where we need to identify any records having same Parent ID and with the same CSA ID, in this case we pick the longest CRISP Parent Full Name and only display one record with their aggregate P0 - P15</P><P> <BR /> <BR /> <BR /> <BR /> <BR />Example as I attached.</P><P> <BR /> <BR /> <BR /> <BR /> <BR />Thank you.</P></BODY></HTML> Wed, 11 Feb 2015 10:50:24 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/784667#M664691 priyarane 2015-02-11T10:50:24Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/784668#M664692 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P></P><P>Try like this:</P><P></P><P>Aggr(count(feildname),dimension)</P><P></P><P>in your case </P><P>Aggr(count(filedname),<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Parent ID,CAS<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> ID)</SPAN></SPAN></P><P></P><P></P><P>Please provide the same data and app that will be more helpful to frame an expression </P></BODY></HTML> Wed, 11 Feb 2015 11:05:10 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/784668#M664692 avinashelite 2015-02-11T11:05:10Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/784669#M664693 <HTML><HEAD></HEAD><BODY><P>Ruben has answered for this, you can check it on below link</P><P></P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/712595#712595"><SPAN style="color: #0066cc; text-decoration: underline;">http://community.qlik.com/message/712595#712595</SPAN></A></P></BODY></HTML> Thu, 12 Feb 2015 13:26:06 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/784669#M664693 priyarane 2015-02-12T13:26:06Z