topic Re: hierarchies in load script in QlikView

hierarchies in load script

Anonymous — Wed, 13 May 2015 09:38:15 GMT

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

avinashelite — Wed, 13 May 2015 09:42:11 GMT

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 — Wed, 13 May 2015 09:45:01 GMT

check this document :