Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
vlastimilkosik
New Contributor III

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
vlastimilkosik
New Contributor III

Re: Activating one filter deactivates other filter.

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.