Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To get the top n values for a specific id by a another column

Hi All,

I have three fields Code,Name and index.

I need to calculate the name field such that in a pivot table when i expand code it has to give me the top 20 names by the index.

i have attached the sample document showing the chart that i need.

i used something like

=aggr(if((rank(sum([Index]))<=20),Name),Name)

Can some one help me please.

Thanks.

0 Replies