Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ani_44
Contributor
Contributor

QlikView Hierarchy Tree View List Box

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.

 

 

Labels (3)
2 Replies
hic
Former Employee
Former Employee

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
Contributor
Contributor
Author

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