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

Announcements
Join us in Bucharest on Sept 18th 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