Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

hierarchies in load script

Hi

I want to create a hierarchy in my script. I have his table:

salesman city region sales

And I want to create this hierarchy: region -> city -> salesman

I want to use it in a listbox or doing selections

I don' want a ciclic group I need a hierarchy in the scrit.

How can I do it?

Can you give an example of script?

Thanks in advanve

2 Replies
avinashelite

Hi

please find the example script below:

Hierarchy(NodeID, ParentID, NodeName) LOAD

NodeID,

ParentID,

NodeName,

Attribute

FROM table

you need to have a relational table with nodeid and its parent id to achieve the Hierarchy

avinashelite

check this document :