Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hierachy and hierarchy belongs to

Any one explain the difference between hierarchy and hierarchy belongs to?

3 Replies
Not applicable
Author

hi

Not applicable
Author

hi

The hierarchy prefix is used to transform a hierarchy table to a table that is useful in a QlikView data model.

The hierarchybelongsto prefix is used to transform a hierarchy table to a table that is useful in a QlikView data model.

Hierarchy is used to create an Expanded Nodes table, where each level in the hierarchy is stored in a seperate field.  This makes it ideal for use in a listbox treeview, or a pivottable.

HierarchyBelongsTo is used to create an Ancestors table, which contains one record for every child-ancestor relation found in the data.  This makes it better suited for allowing selection of entire trees of data.

vikasmahajan

Go through this

Hierarchy Belongs to

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.