Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

self referenced table

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

1 Solution

Accepted Solutions
chriscammers
Contributor III

Re: self referenced table

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.

1 Reply
chriscammers
Contributor III

Re: self referenced table

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.

Community Browser