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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to prevent a value from being selected in the MuliSelect Box ?

All, The version being used is 8.2.

My requirement is say a field ALPHA has A,B,C,D,E,F.

When ALPHA is used in the multiselect it will show up with all these 6 values for selection. I need, say, C,D to get grayed out and user should never be able to select that.

Any suggestions ?

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

The attached isn't quite what you're asking for, since it sounds like you want the values permanently locked. However, in a couple applications, I've locked out some values by default, and stuck a padlock next to them that you can right click on to unlock the values.

You connect a flag to only the values you want unlocked, with null for the other values. Then you create a list box for that flag, and give it a display format of windows checkboxes. Checkmark it and lock it. That creates the padlock. Remove the caption and shrink it until only the padlock displays. Stick the padlock next to the locked values.

Now go into document properties, triggers. Set up an action on the flag so that when it is unlocked, you select excluded on the flag. Unlocking now removes the checkmark, and thus unlocks your real field values. All that's left is to remove the checkbox. In its properties, under layout, add a conditional show of getselectedcount(Locked?). The padlock will then disappear when unlocked.

View solution in original post

5 Replies
Anonymous
Not applicable
Author

I don't want to sound too simple, but simply don't load the data values.

JS

johnw
Champion III
Champion III

The attached isn't quite what you're asking for, since it sounds like you want the values permanently locked. However, in a couple applications, I've locked out some values by default, and stuck a padlock next to them that you can right click on to unlock the values.

You connect a flag to only the values you want unlocked, with null for the other values. Then you create a list box for that flag, and give it a display format of windows checkboxes. Checkmark it and lock it. That creates the padlock. Remove the caption and shrink it until only the padlock displays. Stick the padlock next to the locked values.

Now go into document properties, triggers. Set up an action on the flag so that when it is unlocked, you select excluded on the flag. Unlocking now removes the checkmark, and thus unlocks your real field values. All that's left is to remove the checkbox. In its properties, under layout, add a conditional show of getselectedcount(Locked?). The padlock will then disappear when unlocked.

Not applicable
Author

Thanks John.

That was very helpful.

Not applicable
Author

Hi

In the presentation tab you can select Hide exclude for the field.

Then you cant see C and D.

Anders

Not applicable
Author

Hi Anders.

I don't want to hide it.

Instead i want to disable the selection for a particular value.