Filter Based on Expression Results

[#1]

Hi,

I have expressions to rank companies based on the selected ratio and assign them to three categories of "G", "S" and "B".

I also want to grant user the possibility to filter the table by the categories I mentioned. (ex. only the "G" category or "S" and "G" categories.)

I have come across a discussion with almost the same topic that advised to calculate the categories in the script, but I couldn't go for it since my calculation depends on a ratio which the user must select.

I would appreciate any assistance about the subject.

I've attached a sample Qlikview.

[sunny_talwar · Accepted solution]

Can you try the attached?

I have used a calculated expression to determine the S, B, G in the list box:

=Aggr(if(Only({1}Aggr(rank(Sum({1<Year={2015},Ratio={$(=SelectedRatio)}>}Value),4),Company))<2,'G',

if(Only({1}Aggr(rank(Sum({1<Year={2015},Ratio={$(=SelectedRatio)}>}Value),4),Company))<5,'S','B')), Company)

[#3]

Thanks.... that worked perfectly fine....