topic Re: grouping in QlikView

grouping

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

I have requirement like below :

For Company Code=A and Code=Code1 , I want top 5 Age values in my Age Field irrespective of my expression:

For Above case top 5 Ages are :

For Company Code=B and Code=Code2 , I want top 5 Age values in my Age Field irrespective of my expression:

For Above case top 5 Ages are :

Could you please help here , how to do it ?

settu_periasamy — Wed, 21 Feb 2018 06:23:50 GMT

Try this.

=Sum({<Age={"=aggr(rank(sum(Age)), Company,Age)<=5"}>}Val)

shiveshsingh — Wed, 21 Feb 2018 06:54:20 GMT

Hi Try this

=Sum({<Emp={"=aggr(rank(sum(Age)),Company,Age)<=5"}>}Age)

subbareddykm — Wed, 21 Feb 2018 07:10:24 GMT

Its is not working in app, for all Company Code, For some company's not coming top 5 when I select any company and Code then it is working

Is it possible to create it in Script level ?

shiveshsingh — Wed, 21 Feb 2018 07:48:09 GMT

Have you tried this?

=Sum({<Emp={"=aggr(rank(sum(Age)),Company,Age)<=5"}>}Age)