topic Re: Tree Hierarchy selection in QlikView

Tree Hierarchy selection

Wed, 18 Jun 2014 21:19:27 GMT

Hi everyone,

I am new to Qlikview.

I created a tree hierarchy for three fields. Sector -> Segment -> Sub-segment. However, in my list box, I would like to be able to select a sector, and have it automatically select all relevant segments and sub-sugments. Is this possible?

Thanks!

Re: Tree Hierarchy selection

MarcoWedel — Wed, 18 Jun 2014 21:25:14 GMT

The sector values must be included as seperate values in the field.

hope this helps

regards

Marco

Re: Tree Hierarchy selection

Wed, 18 Jun 2014 21:25:19 GMT

HI,

In fact, QlikView return all possible values associated of your selection. If you select a Sector, QlikView return all possibles Segment and Sub-segment values.

Best regards

Re: Tree Hierarchy selection

Wed, 18 Jun 2014 21:38:23 GMT

Thank you both very much for your responses.

Right now, my list box is using a Field that we constructed in Excel, with the three levels concatenated in a separate column as "Sector"-"Segment"-"Sub-Segment". We then selected "Show as TreeView", with separator -.

Does this method not allow me to select a sector or segment in the list box, and automatically select everything beneath it?

Re: Tree Hierarchy selection

MarcoWedel — Wed, 18 Jun 2014 21:49:19 GMT

Add additional rows in your excel sheet which contain only the selector value without "-"and segment or sub-segment values. One row for each distinct selector value.

Regards

Marco

Re: Tree Hierarchy selection

Wed, 18 Jun 2014 22:00:43 GMT

Thank you! That helps

Re: Tree Hierarchy selection

Wed, 18 Jun 2014 22:01:03 GMT

Marco's answer explained this, and I also found an example here: Hierarchy in QlikView

Re: Tree Hierarchy selection

qliklearnervir — Wed, 11 Sep 2019 11:58:28 GMT

Hi Macro,

I have an issue with a tree-view list box that I want to show same tree-view list box in multiple sheets.

when expand and collapse list box in 1 sheet, I want same list box should show in other sheets with same expand and collapse.

I tried but I feel, this feature is not available in QlikView.

Sheet 1 list box image.

SHeet 2 list box image

Re: Tree Hierarchy selection

PriyankaT — Wed, 23 Feb 2022 11:00:17 GMT

I am facing the same issue. How it got resolved? Can someone please elaborate in detail