Aggregation

[priyarane]

Hi Experts,

I got a difficult issue like below. Please help me on it.

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

Example as I attached.

Thank you.

[avinashelite]

Hi Priya,

Try like this:

Aggr(count(feildname),dimension)

in your case

Aggr(count(filedname),Parent ID,CAS ID)

Please provide the same data and app that will be more helpful to frame an expression

[priyarane · Accepted solution]

Ruben has answered for this, you can check it on below link

http://community.qlik.com/message/712595#712595