topic Re: Multibox: Can you limit dropdown option to just specific field(s)? in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

trdandamudi — Wed, 25 Jan 2017 18:03:01 GMT

Hope the below link will help...

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

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

eespiritu — Wed, 25 Jan 2017 18:05:12 GMT

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,

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

surendraj — Wed, 25 Jan 2017 19:02:25 GMT

Hi Trista,

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

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

please clarify me..!

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

Wed, 25 Jan 2017 20:29:03 GMT

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

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

Wed, 25 Jan 2017 20:40:59 GMT

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.

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

eespiritu — Wed, 25 Jan 2017 21:25:44 GMT

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

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

surendraj — Wed, 25 Jan 2017 21:38:44 GMT

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.

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

rwunderlich — Wed, 25 Jan 2017 21:42:13 GMT

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

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

Wed, 25 Jan 2017 21:47:01 GMT

Ok thank you for your input!

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

Wed, 25 Jan 2017 21:51:43 GMT

I think we will just set them all to Read only, as the selection of the Project Number occurs on a different dashboard and the user just needs to view the details from the multiboxes.

Thank you for your suggestions!

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

Wed, 25 Jan 2017 21:54:57 GMT

Yes, Rob, it was too also limit making incompatible selections that would remove/change the Project Number selection value. The lock appears to lock the entire table, which is fine, but then it becomes locked in other dashboards too. So, we will just set the table to be Read only, as really, this is the purpose after the user select a particular Project Number from a different dashboard.

Thank you for your suggestions! I believe they will come in handy for future efforts!

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

eespiritu — Wed, 25 Jan 2017 22:02:42 GMT

Maybe this can be useful:

On Multibox object, remove the fields that you want "disable" from Fields Displayed in Multibox, now click on Expression > button and add the next:

=if(len(GetCurrentSelections(ProjectField)) > 0,'',PARNumberField)

Apply this function for each field.

Regards,

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

rwunderlich — Wed, 25 Jan 2017 23:25:55 GMT

If you just want the user to view the data and not make selections, why not use a chart instead of a multibox?

-Rob