Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Beginner Questions About Hierarchy Load


I am attempting to create links between different rows belonging to one single table. I think that the solution to my problem would be a Hierarchy Load, but I can not seem to get it to work.

I am unsure that I understood the requirements correctly though. The way I understand Hierarchy Load is, that it requires an ajacent nodes table. It requires a NodeID and ParentID. In my table, I have the ID field and a ParentID field that is simply the ID of the parent row. This should fulfill the criteria required for Hierarchy Load.

Naturally, in addition to those, I also have plenty of other fields in the table. My first question is, are these extra fields a problem for the Hierarchy Load?

Secondly, I just finished my first successful Hierarchy Load (lasted a mere 25 minutes...) and it's removed the table that it was loaded from altogether! Should I have created a separate "buffer" adjacent nodes table that takes the ID and parentID from my table, and then use that to do the Hierarchy Load?

Any help would be greatly appreciated!