topic Group Field in Multi Box in QlikView

Group Field in Multi Box

Mon, 28 Mar 2011 10:17:33 GMT

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

Group Field in Multi Box

ashfaq_haseeb — Mon, 28 Mar 2011 10:28:45 GMT

You don't have any data in the application.

anyways you can use if conditions to acheave the same.

Regards

ASHFAQ

Group Field in Multi Box

Mon, 28 Mar 2011 11:01:35 GMT

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.

Group Field in Multi Box

Mon, 28 Mar 2011 11:05:11 GMT

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

Group Field in Multi Box

Mon, 28 Mar 2011 11:13:22 GMT

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.

Group Field in Multi Box

Mon, 28 Mar 2011 11:19:24 GMT

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.

Group Field in Multi Box

Mon, 28 Mar 2011 11:30:33 GMT

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

Group Field in Multi Box

Mon, 28 Mar 2011 11:35:25 GMT

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

Group Field in Multi Box

Mon, 28 Mar 2011 11:52:50 GMT

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

Group Field in Multi Box

pat_agen — Mon, 28 Mar 2011 12:11:29 GMT

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.

Group Field in Multi Box

Mon, 28 Mar 2011 12:17:54 GMT

Hi Matthew,

I guess if you created a mapped load statement with columns Country, Continent, you could try to use set analysis with the Possible option. But this is however the "dark side of the force" to me. Very powerful, but also quite mysterious.

The best call would be to use the hierarchy function. Don't get too complex about it, just map the right field names in your enviro to the parameters in the function. Hierarchy function is also quite useful, especially the hierarchybelongsto, but I am not the right person to ask about how to implement in practice.

If I was in your shoes, I'd just do a basic hierarchy load, put a front end list box i TreeView mode and allow end users to make a selection on this. The problem with set analysis is the structure (mapping) has to already exist, even if you are using "possible" (P...) in set analysis, hence you will anyhow have to alter the script to some extent, unless you already have the mapping structure existing in your data model.

Sorry I can't be of any further help. Maybe someone else will come up with a different, fast and smarter to way to get what you need.

Group Field in Multi Box

Mon, 28 Mar 2011 12:26:55 GMT

Thanks Pat - works perfectly.

Question, in the expression:

=if(match(Country,'France','Greece',' Spain','Belgium','Germany')>0,'EU')

Is the greater than zero a bin width?

Thanks

Matt

Group Field in Multi Box

Mon, 28 Mar 2011 12:28:31 GMT

Thanks Cheenu, as I mentioned earlier, I think your approach is the best long term. However today I was looking for a quick fix using set analysis.

Really appreciate the help.

Matt

Group Field in Multi Box

pat_agen — Mon, 28 Mar 2011 12:50:23 GMT

hi,

the match() function compares the field Country against the values. If country was France then it would return 1, if Greece 2 and so on. If nothing matches it will return 0. If you put the field Country instead of the text 'EU' the drop down list would list all the countries in your function. insead of that it just shows the text 'EU'. So this expression is basically adding the attribute EU to all the countries you list inside the function.

It does what you want but best practice - for something as relatively unchanging as a country name and membership of an instutional group such as the EU would be best adressed by mofifying your load statement and adding the field CountryGroup for example with a value 'EU' for each member state. this could then be used all over your document rather than at each time having to use a complex function or set analysis.

just code it like this:

LOAD * INLINE [
Country, CountryGroup
Viet Nam, other
Iceland, other
Mozambique, other
Honduras, other
Japan, other
Kazakhstan, other
France, EU
etc.
etc.