Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Disable Values

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!!!!

4 Replies
its_anandrjs

Hi,

Yes make a trigger for selection fields.

Thanks & Regards

Anonymous
Not applicable
Author

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

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
Partner - Creator III
Partner - Creator III

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!