Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Activating one filter deactivates other filter.

I just wonder if there is an option to do the following:

I have two filters:

1. Profitable Companies based on 4year weighed average

2. Profitable Companies based on 3year weighed average

Obviously it does not make sense to use both at once. Thus, i am wondering if there is an option to use something like "getfieldselections" or something similar to actual deactivate one filter if the other one has been selected. (each filter works as a dummy variable, there is either a company marked as profitable based on the weighed average relevant for the type of calculation, or value is a null)

thx

1 Reply
Anonymous
Not applicable
Author

bringing up my post:

also, I have tried something as the following code:

if(getfieldselections([Three Years History]) = 'Three Years History',

  if([Company earned weighted average operating loss] = 'Accepted', 'Profitable Companies 3Y'),

    if([Company earned weighted average operating loss 4Y] = 'Accepted', 'Profitable Companies 4Y'))

This works following:

Filter Three Years History not active & the above presented filter not active --> all working fine (obviously)

Filter Three Years History active & the above presented filter not active --> all working fine

Filter Three Years History active & the above presented filter active --> all working fine

last option

Filter Three Years History not active & the above presented filter active --> activation of this while Three Years Filter is not active starts some weird actions

1. it activates automatically the filter Three Years History

2. activates the if([Company earned weighted average operating loss 4Y] = 'Accepted', 'Profitable Companies 4Y'))

3. gives nonsense results as it is combining the options that are basically impossible to combine

3y history + average based on 4years...

is this a bug or is this intended?

I Mean I would expect that this would work in a following logic

"If there is current selection x, use this filter, else use that filter" and that is it.. this seems that having that if(getfieldselections) in a given filter I can actually activate the other filter value which seems very weird to me.

Edit: Added a qvf (simplified version where you can see the functionality of what I mean, each filter is there as typical Qlik Filter as well as "list box version" second one is an extension.