topic Re: QlikView Hierarchy Tree View List Box in QlikView

QlikView Hierarchy Tree View List Box

Ani_44 — Wed, 30 Mar 2022 20:20:59 GMT

Hello Guys,

In QlikView I was trying to create a Hierarchy Tree View list box using Hierarchy function , I was able to get expand and collapse buttons using list box but not able to get actual data. I have attached a sample files. I hope some one can help me what I am doing wrong here.

Re: QlikView Hierarchy Tree View List Box

hic — Thu, 31 Mar 2022 08:26:16 GMT

Hmmm... You may have discovered a bug here. It doesn't seem to accept numeric node names. I need to look into this.

Meanwhile, a work-around is the following: Change your Load statement to the following, and it will work:

Hierarchy (CHILD_ID, PARENT_ID, SUB_NUMBER,ParentName,PathSource,Path, '\', Depth)
LOAD GLOBAL_NUMBER,
Text(SUB_NUMBER) as PathSource,
SUB_NUMBER,
LINKAGE,
//NUMBER_LINKAGE,
CHILD_ID,
PARENT_ID
FROM [Hierarchy Tree View Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);

Re: QlikView Hierarchy Tree View List Box

Ani_44 — Thu, 31 Mar 2022 14:17:08 GMT

Thank you Henric, might be a bug it worked when converting to text.