Multibox: Can you limit dropdown option to just specific field(s)?

[#1]

I created a Multi Box Object with a few fields. By default, the dropdown option for each field is enabled allowing users to select other values for any of the fields. However, we'd like to limit that ability to just one or two fields. Is this possible? If it's an all or nothing option, how would I turn to dropdown option off?

Thanks for your support!

Trista

[trdandamudi]

Hope the below link will help...

http://www.qlikfix.com/2014/07/08/building-nicer-dynamic-multibox/

[eespiritu]

Hi Trista,

My advice is to use Section Access to reduce data for each user, using this functionality the users will see only allowed values in each field.

Regards,

[surendraj]

Hi Trista,

Do you want to limit the field values in drop down for particular field?(show only some values in drop down)

OR

Do u want to disable the drop down option for particular field?

please clarify me..!

[#5]

Hi surendra j....I want to disable the drop down option for particular field(s).

[#6]

Hi Enrique Espiritu...If I'm understanding Section Access correctly (referring to Introduction to Section Access), it's to limit certain data from being accessed or viewed by certain people. We don't want to limit the visibility of the data.

What I'm trying to do is, based on a selected field value, Project Number for instance, I don't want any of the other fields in the multibox to be selectable, which would render different and/or unexpected results.

[eespiritu]

Got it.

But, unfortunately I don't think that this could be possible, the example that you shows is similar to "enable/disable" objects when you select a value in a field. I checked all trigger actions and I don't see any possible option for this.

I found a similar discussion: https://community.qlik.com/thread/66801

[surendraj · Accepted solution]

Hi Trista,

Thanks for info!!

I think there is no direct option for disable the drop down option for particular filed(s) which are displayed in fields displayed in multibox in general tab.

But based on Your Requirement you may do

Properties-->presentation-->Read only(lest bottem)

If you enable this option you can restrict the particular feild from selection.(That field is only useful for view/read only).

(OR)

In Properties-->general-->fields displayed in multibox-->select the your required feild-->settings for selected feild--->In label-->you can specify label name as space(just press the space button).

By this your particular filed will be invisible in application.

(OR)

You can use both the ways at the same time.(make field invisible in application and read only),if your requirement is relevant to what I am suggested.

[rwunderlich]

Is the purpose to avoid making incompatible selections that would remove the Project Number selection? If so, then

First suggestion: Teach people how to lock fields so they don't have this problem. Or lock the field yourself with a trigger or a button.

Suggestion two. Assume OrderId is the key field (like Project Number) in this case and you want to limit selections in Country to only associated values, Instead of putting Country directly in the multibox, use an expression like:

=aggr(Country, Country)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#10]

Ok thank you for your input!