I truly appreciate this forum. I do try to search the internet and try a bunch of work prior to posting on the boards. So, if I can improve on how I write up my questions to get better answers, please provide feedback too.
Question: I want to get the top Episodes for people who have more than $250,000 in Amount Paid.
I can get all of the people I just can't get the Episodes associated with those people:
How about this - set up a calculated dimension for your Member ID thusly: =IF(Aggr(Rank(SUM([Amount Paid]),4),[Member ID])<=5,[Member ID]) Then uncheck "Include Null Values" on the dimension in your table Your expression can then be set to SUM([Amount Paid]) to see their total amount and only display the top 5 rows.
Thanks Andoryuu for the response. I posted an example of the data and the outcome. I should also state that I am using Qlik Sense through a web interface. While I have the ability to do Sets, I do not have the ability to customize the data load process. For the solution you proposed for creating a calculated dimension, I do not have the option to do that. I can create a Filter Pane using the same idea then just go in and "Select All". After selecting all, I could then just create a table and then create a set using Episode and rank to get the top episodes. I would have a table of Episode, Sum Amount.
How do I, in the set, create just a view of the top 2?
My actual list is returning over 1,000 people and 1,500 Episode types. So I really just want the top 5 episodes based on the 1,000 people's experience. So my initial set gives me the 1,500 episodes for the costs of the people (based on changing the dimension to episode, like you suggested), but I can't limit the returned episodes to just the top 5 using the set.