QlikView Hierarchy Tree View List Box

[Ani_44]

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.

[hic]

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);

[Ani_44]

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