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: 
Anonymous
Not applicable

Show top n in a straight table

I have the following columns (among others) in a straight table.

Provider (dimension, and controlled by a filter)

Failed3Day (expression)

I have a button that I want to use to show only providers that have the 20 highest values, and sort the table on the Failed3Day column from highest value to lowest.

I assume that I want to create a "Select Field" action, and I've made a few attempts at using the RANK method, but I can't seem to wrangle it into submission. Can anyone help?

1 Solution

Accepted Solutions
sunny_talwar

See if the attached makes sense

View solution in original post

6 Replies
sunny_talwar

Would you be able to share a sample where you attempted this?

sunny_talwar

See if the attached makes sense

Anonymous
Not applicable
Author

I can show you the last thing I tried. but I can't share the actual data.

This is the last search string I tried for the action (Icreated a smaller data set with fewer columns and rows to play with):

=AGGR(IF(RANK(TestFailed)<=20, TestProvider),TestProvider)

sunny_talwar

How about this?

='=Rank(TestFailed) < 21'

Here I am assuming that your expression in the chart is TestFailed (with no aggregation like Sum or Avg)... Is that right?

Anonymous
Not applicable
Author

That was it. Thanks.

sunny_talwar

Awesome