Represent tree association

[josecanalla]

Hello, I have a table "Accounts" with this fields:

• ID
• Name
• Father_ID

Where "Father_ID" is a foreign key to the "ID" of the same table. This creates a n-level tree of Accounts.

How can I represent this in QlikSense?

Thanks!

[Gysbert_Wassenaar]

You can use the Hierarchy and HierarchyBelongsTo functions like explained in this blog post: Unbalanced, n-level hierarchies. These work in Qlik Sense too.