Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter Based on Expression Results

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.

1 Solution

Accepted Solutions
sunny_talwar

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)


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

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)


Capture.PNG

Not applicable
Author

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