Discussion Board for collaboration related to QlikView App Development.
I have the following columns (among others) in a straight table.
Provider (dimension, and controlled by a filter)
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?
Go to Solution.
See if the attached makes sense
Would you be able to share a sample where you attempted this?
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):
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?
That was it. Thanks.