topic Disable Values in QlikView

Disable Values

Thu, 13 Mar 2014 19:03:04 GMT

Is there any way to disable values in a Multiple Selector object?

For example, I have a field Category with values A, B y C.

I want to select values A and B by default when I open the App.

Is there any way to disable the value C, so that I couldn't select it?

Thank you!!!!

its_anandrjs — Thu, 13 Mar 2014 19:58:02 GMT

Hi,

Yes make a trigger for selection fields.

Thanks & Regards

Anonymous — Thu, 13 Mar 2014 20:03:58 GMT

It depends on what you want...

If you don't ever to have value C, filter it out in the script.

If you want to have it but not in filter, create an additional field, same as Category but doesn't include value C.

If you want all three values in filter but C not available for selection, select A and B by trigger, as Anand Chauhan suggests, and lock the field.

its_anandrjs — Thu, 13 Mar 2014 20:08:28 GMT

Hi,

Right click on the sheet properties and select triggers option and in sheet event triggers click add action

select there select in field option and click ok then in field option select field and in search string type your field.

Thanks & Regards

bgerchikov — Thu, 13 Mar 2014 22:09:55 GMT

You can create expression in the list box as follows:

aggr(only({<Field={'A','B'}>}Field),Field)

so it will show A and B only with option to select one of them or both

Thanks!