how to make filter which is grayed when not applicable to unclickable ?

[Anonymous]

Hi ,

   If I select any one of my filter in dashboard shows few options grayed when not applicable .. is there any way to make it unclickable ??(even though it is not applicable ,by clicking on it makes the other filter get removed atomaticallay)

[jwjackso]

Can you use the "Hide Excluded" option in the List Box properties?

[jaumecf23]

Hi,

Go to the List Box Propierties of your Filter. Then in the General tab there is an option to "Hide Excluded". Select this option and try again.

[Anonymous]

Hi  Jaume,

  Where can  I find the list box properties in qlik sense ?

[jwjackso · Accepted solution]

I did not notice you were in Qlik Sense.  In the filter pane I tried the following expression:

=Aggr(If(count({<Dim1=P(Dim1)>}Dim1) > 0,Dim1,Null()),Dim1)

Where Dim1 was my dimension.

[Anonymous]

Thank you Jerry  the expression is working .