Discussion board where members can get started with Qlik Sense.
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?
Go to 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
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.