Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there a possibility to disable a specific value of a field in multiselector?

Is there a possibility to disable a specific value of a field in multiselector?

eg:

If i have a field called Date in the multiselector, and if it contains 5 values

1/1/2000

1/2/2000

1/3/2000

1/4/2000

1/5/2000

can I disable just 1/1/2000?

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

I can see two alternatives:

1 - easiest one - create a list box with an expression instead of a field.

The expression can be like this:

=if(Date<>makedate(2010,10,05),Date)

The date excluded by the expression will not appear.

2 - Very complicated - I would create a field with is a copy of the one you want to controle (Date2 as a copy of Date) then you would make a selection on all the values except the one you want to exclude and lock it . All this by macros. The user would see a field with the excluded value in gray.

View solution in original post

4 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

You can select 1/1/2000 and after selection right click and choose Select Excluded.

Is this what you need?

Not applicable
Author

Hi Rakesh,

I want 1/1/2000 to be diabled in the multiselectors, so that user would not be able to select it.

This that possible?

erichshiino
Partner - Master
Partner - Master

I can see two alternatives:

1 - easiest one - create a list box with an expression instead of a field.

The expression can be like this:

=if(Date<>makedate(2010,10,05),Date)

The date excluded by the expression will not appear.

2 - Very complicated - I would create a field with is a copy of the one you want to controle (Date2 as a copy of Date) then you would make a selection on all the values except the one you want to exclude and lock it . All this by macros. The user would see a field with the excluded value in gray.

Not applicable
Author

Thank you, I used your list box suggestion