Disable clicking on grayed out values

[#1]

Hi,

I have a few list boxes in my dashboard, which has a few values grayed out. The dashboard opens every time with a set of filters with a few values grayed out in the list boxes. But, when a user selects any grayed out value from the list boxes, it overrides my initial state of dashboard. So, is there a way to disable user clicking on a value that is grayed out?

Thanks!

[jpenuliar]

You can set the "Hide Excluded"  property of the Listbox

[jpenuliar]

Or you can choose to Lock/Unlock the Selections

[MK_QSL]

You can create list boxes by using below expression instead of using field name directly.

Say your list box is of Customer.

Create List box using below expression.

=AGGR(Customer,Customer)

This will only show possible values of list boxes.

[#5]

I want the grayed value to be shown, but disable any selection on the grayed out value. I want the selections to be available on the values with a white background. If the Lock/Unlock selections it does not allow me to make any selection.

[#6]

Already used this expression. It wipes out the grayed out value. I want the grayed value to be shown, but disable any selection on the grayed out value.

[MK_QSL]

Disable/grey out items in list box

[#8 · Accepted solution]

Closing this thread, as I found a way out to solve the issue. I had to add actions on a variable that checked if there were any filters on currentselections.