Group Field in Multi Box

[#1]

Hi,

I have a multi box with a country drop down list. I would like to group the European Union countries within the list under the heading EU so that when EU's selected, all EU countries are chosen. Without this functionality, I need to hold ctrl and select each country one at a time.

Any suggestions would be appreciated, unfortunately I haven't been able to find any posts that address this issue. I've included a sample doc with the country list I would like to create the group for.

Best,

Matt

[ashfaq_haseeb]

Hi

You don't have any data in the application.

anyways you can use if conditions to acheave the same.

Regards

ASHFAQ

[#3]

Hi Matthew,

It looks like you should be searching posts on the Hierarchy function (if you have an adjacent nodes table). Then in the front-end, use a list box with the TreeView option.

I'll do a quick search on my sample QVWs and post one example for you.

[#4]

Matt,

Your example is empty so can't be entirely sure of your problem. Unless I'm missing something all you need is some sort of qualifier for each country? See example.

Thanks, Gary

[#5]

Attached QVW with an Inline load of Parent-Child relationships of continents, countries, etc.

Clicking on a colllapsed Parent Node (when the Parent Node shows the "+"-sign) automatically makes a selection on ALL the underlying children nodes.

Clicking on the Parent Node name when the node is expanded, only takes the Parent Node as a selection, not all the underlying children nodes.

Check attached QVW and click around to see how it works.

[#6 · Accepted solution]

Hi Matthew,

From the specs perspective, it looks like the only way around is creating a TreeView list box, i.e. how to select EU and take all underlying selections for that node (i.e. all the EU countries).

This can be done with a TreeView list box when the EU node is collapsed. If the EU node is expanded then clicking on EU will only select this one, not any of the underlying nodes.

The reason for this way of functionining is because paarent-nodes might be entities in themselves. For e.g., many European HQs for organisations are in the Netherlands for tax reasons. However, the Dutch offices have 2 roles, EU HQ and also office for the NL. Hence, the treeview list box would allow for a selection of the Dutch/EU region when the node is collapsed and when the node is expanded, it would just select that EU HQ office, as opposed to all the underlying offices in the EU that fall under the corporate umbrella of the EU HQ office in NL.

Hope that makes sense.

[#7]

Apologies for the empty data set. Should be populated now. Goal is to create a group within the list of countries called "EU" that groups together EU countries.

Thanks in advance.

Matt

[#8]

Hi Cheenu,

Thanks for the response. This is probably the best solution and likely what I'll implement. Due to time contraints I was hoping for a quick solution with set analysis, but perhaps this isn't doable.

Thanks again.

Matt

[#9]

Any ideas on how to solve this problem just using set analysis? Would like to avoid adding nodes and altering the load statement.

Best,

Matt

[pat_agen]

Hi Matt,

check the attached qvw. There is another element in the drop down box. Select 'EU' and you will get the EU countries selected (i haven't put them all in as i'm scared of forgetting one and upsetting someone! )

this is done with an edited expression in your multibox obeject.

set analysis will work on expressions. and for the moment you haven't got any of those.