Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
Can you use the "Hide Excluded" option in the List Box properties?
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.
Hi Jaume,
Where can I find the list box properties in qlik sense ?
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.
Thank you Jerry the expression is working .