I'm sorry I didn't make it clear, I'll describe it in a simple way .
load * Inline [
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.
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.
I've tried it, but it's still wrong.
Expression for Country:
Expression for 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.