Mutual exclusion of filters

[Anonymous]

  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。

消息编辑者为：lisa lu

[cazztfplease]

Hello Lisa,

To clarify, you are not able to select any of these filters?

[Anil_Babu_Samineni]

That means 2 approached are bad

1) Data model wrong, May be

2) In your source might they doesn't have associate one. Can you try with simple table and check how testing is under.

[Anonymous]

I can select this filters,but I want to unable select this filters .

-Original-

[woshua5550]

Hi lisa

you may need to attach your .qvf file and data source if possible

by the way , 你是中国人吧？ 哈哈，这里很少见的。

[Anonymous]

I'm sorry I didn't make it clear, I'll describe it in a simple way .

source:

load * Inline [

Country, City

A, a1

A, a2

A, a3

B, b1

B, b2

B, b3

C, c1

C, c2

C, c3

];

if I select "A" or "B" in the "Country" filter，I can't select any option in the "City" filter.And vice versa.

My attempt on "City"：

     if(GetSelectedCount(Country)=0,City). 

But that's wrong.I can't use this expression on "Country" and "City" at the same time.

Can you solve this.

[Anonymous]

对呀，我是中国人，我的表述不大清楚，其实我想知道多个筛选项能不能相互独立存在，当我在A字段里做了筛选后不能在B字段里做筛选，反之亦然。我试着用GetSelectedCount（）函数，但是只能在一个字段里面写表达式，还只能单向选择，反选就不行。请问有没有解决的方法？

[pradosh_thakur]

Hi Anil

i guess here the requirement is disable two filters when one is selected. May be i am wrong.

regards

Pradosh

[Anil_Babu_Samineni]

Sometimes, If data model is wrong then it may not associate as expected because of data granularity issue it triggers the issue.

[pradosh_thakur]

why don't you use set expression in your chart or table to select only the selected filters data

or else another workaround can be  please check your field name as it can be case sensitive

expression for time

if (getfieldselection(product)>0 or getfieldselection(infor)>0,null(),time)

expression for product

if (getfieldselection(time)>0 or getfieldselection(infor)>0,null(),product)

expression for infor

if (getfieldselection(time)>0 or getfieldselection(product)>0,null(),infor)

if this doesn't help please post your sample app.

regards

Pradosh