Solved: How to load a tree - Qlik Community

JMAROUF · ‎2022-03-20

Hi everyone,

I want to load a tree from an xls file, my goal is to extract all parents/childs of a category when I select it's name,here is an example:

PS: Please note that the name here is just for the example, the real table is tied to a complicated star schema.

Input:

Output when i select cat_a:

Output when i select cat_z:

Any help please ?

Lisa_Sun · ‎2022-03-28

You can use hierarchy and HierarchyBelongsTo.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!

Lisa_Sun · ‎2022-03-28

You can use hierarchy and HierarchyBelongsTo.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!

How to load a tree