topic Filter Based on Expression Results in QlikView

Filter Based on Expression Results

Tue, 26 Apr 2016 12:19:29 GMT

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.

Re: Filter Based on Expression Results

sunny_talwar — Tue, 26 Apr 2016 16:35:12 GMT

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)

Re: Filter Based on Expression Results

Wed, 27 Apr 2016 06:49:06 GMT

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