Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

priyarane
Contributor III

Aggregation

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.

1 Solution

Accepted Solutions
priyarane
Contributor III

Re: Aggregation

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

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

2 Replies

Re: Aggregation

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
Contributor III

Re: Aggregation

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

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

Community Browser