Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any one explain the difference between hierarchy and hierarchy belongs to?
hi
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.
Go through this
Vikas