topic Re: Disable clicking on grayed out values in QlikView

Disable clicking on grayed out values

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Disable clicking on grayed out values

jpenuliar — Mon, 28 Nov 2016 18:35:25 GMT

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

Re: Disable clicking on grayed out values

jpenuliar — Mon, 28 Nov 2016 18:38:18 GMT

Or you can choose to Lock/Unlock the Selections

Re: Disable clicking on grayed out values

MK_QSL — Mon, 28 Nov 2016 18:46:57 GMT

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.

Re: Disable clicking on grayed out values

Mon, 28 Nov 2016 19:33:56 GMT

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.

Re: Disable clicking on grayed out values

Mon, 28 Nov 2016 19:34:29 GMT

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.

Re: Disable clicking on grayed out values

MK_QSL — Mon, 28 Nov 2016 19:47:53 GMT

Disable/grey out items in list box

Re: Disable clicking on grayed out values

Tue, 29 Nov 2016 21:59:06 GMT

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.