Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

jsimmonstx
Contributor

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?

Tags (1)
1 Solution

Accepted Solutions

Re: Show top n in a straight table

See if the attached makes sense

6 Replies

Re: Show top n in a straight table

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

Re: Show top n in a straight table

See if the attached makes sense

jsimmonstx
Contributor

Re: Show top n in a straight table

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)

Re: Show top n in a straight table

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?

jsimmonstx
Contributor

Re: Show top n in a straight table

That was it. Thanks.

Re: Show top n in a straight table

Awesome