Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guptanupur
New Contributor II

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

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)

1 Solution

Accepted Solutions
jwjackso
Contributor III

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

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.

5 Replies
jwjackso
Contributor III

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

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

jaumecf23
Contributor III

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

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.

Captura.PNG

guptanupur
New Contributor II

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

Hi  Jaume,

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

jwjackso
Contributor III

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

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.

guptanupur
New Contributor II

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

Thank you Jerry  the expression is working .