self referenced table

[#1]

Hi

I have a table wich references itsellf, like a tree. Anoter table is referenced by the 1st. I want to sow accumutated data of the second table for every record of the 1st (and it's descendats). Is is possible? How?

Thanks

Aniceto Pérez

[chriscammers · Accepted solution]

When you are loading the data you need to process the hierarchy using the "Hierarchy" and "HierarchyBelongsTo" load prefixes. They are described in help

here Hierarchy ‒ Qlik Sense

and

Here HierarchyBelongsTo ‒ Qlik Sense‌

Hierarchy produces an flattened nodes table and HierarchyBelongsTo produces an ancestors table.

The ancestors table is useful for showing measure results for an item and all it's descendants.