Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mutual exclusion of filters

  hi,

    I just started to learn Qlik Sense,I'm sorry about the problem that I was sending out.

    What I want is that when I select a filter , I can't select another filter。

    For example,

     if I select "1年" in the "time" filter,I can't select any option in the "product" and "Infor" filter,Of course, I can continue to select “2年” or “3年” in the "time" filter.

     if I select same options in the "product" or "Infor"filter,I can't select any option in the "time"  filter.

    And all the data comes from a table.

    Can you solve this problem with an expression?

   Thank you in advance。

22.png

消息编辑者为:lisa lu

12 Replies
vinieme12
Champion III
Champion III

is this what you are after?

Comparative Analysis - Alternate States with Qlik Sense

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MK9885
Master II
Master II

Using your Inline code I can see and select the City values. Not sure what problem you facing?

Check your Data model and it's association with other tables.

Untitled.png

Anonymous
Not applicable
Author

I've tried it, but it's still wrong.


Expression for Country:

=if(getfieldselections(City)>0 ,null(),Country)

Expression for City:

=if(getfieldselections(Country)>0 ,null(),City)

I select the "A" in "Country", and then "a1", "a2", "a3" in "City" will be automatically selected, and the two filters will be automatically hidden.

010101.png