topic Tree View Hierarchy - select entire group? in QlikView

Tree View Hierarchy - select entire group?

Thu, 26 Jun 2014 20:24:39 GMT

Hi folks -

I have a hierarchy that displays in tree view. I would like to be able to click on a group and have it select every item underneath it. For instance, if we look at the following example:

FOOD

- Vegetables

- Onion

- Pepper

- Carrot

- Fruit

- Banana

- Apple

- Orange

Right now, I can select Onion, Pepper, and Carrot by clicking them individually or dragging across them. What I would like to do is click "Vegetables" and have it select Onion, Pepper, and Carrot for me. Thanks!

Re: Tree View Hierarchy - select entire group?

Thu, 26 Jun 2014 20:52:19 GMT

This could at least get you started:

For a hierarchy field "Field0", you could add a field event trigger to the OnSelect event.

I tried the action "Select in Field" for field "Field0", using the search string exactly as copy and pasted below:

='*$(=Field0)*'

This works as long as the hierarchy branch that you're selecting is expanded.

Not an ideal solution, but maybe it gives you ideas on how to perfect the interface

See attached.

Re: Tree View Hierarchy - select entire group?

nilo_pontes — Thu, 26 Jun 2014 21:06:36 GMT

Hi Marco,

Try to collapse the group and than select it.

It should works.

Best regards

Re: Tree View Hierarchy - select entire group?

Thu, 26 Jun 2014 21:09:42 GMT

Hi Nilos -

Unfortunately, that doesn't seem to work.

Re: Re: Tree View Hierarchy - select entire group?

nilo_pontes — Thu, 26 Jun 2014 21:41:07 GMT

Marco,

Try it with the attached file, please.

Re: Tree View Hierarchy - select entire group?

MarcoWedel — Thu, 26 Jun 2014 22:23:47 GMT

Hi Marco,

you just have to add the group names ("vegetables", "fruit") as additional rows in your hierarchy field.

hope this helps

regards

Marco 😉

Re: Re: Tree View Hierarchy - select entire group?

MarcoWedel — Thu, 26 Jun 2014 22:38:35 GMT

like this:

LOAD * INLINE [

Dish

Vegetables

Vegetables/Onion

Vegetables/Pepper

Vegetables/Carrot

Fruit

Fruit/Banana

Fruit/Apple

Fruit/Orange

];

regards

Marco

Re: Tree View Hierarchy - select entire group?

Fri, 27 Jun 2014 14:39:13 GMT

Perfect - thank you Marco!