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。
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。
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.
I'm sorry I didn't make it clear, I'll describe it in a simple way .
load * Inline [
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"：
But that's wrong.I can't use this expression on "Country" and "City" at the same time.
Can you solve this.
Sometimes, If data model is wrong then it may not associate as expected because of data granularity issue it triggers the issue.
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.