topic Re: Hierarchy in QlikView in QlikView

Hierarchy in QlikView

vanderson009 — Tue, 10 Mar 2015 11:40:39 GMT

Hi guys,

I want to create employee hierarchy and i have data like

Want to implement ManagerId->TeamleadId-EmployeeId level hierarchy.

Could any one please let me know what script logic i need to use

Thanks in advance.

-Regards,

Villyee

Anonymous — Tue, 10 Mar 2015 11:46:21 GMT

Hi ,

Go through below threads .may be helpful for you .

senpradip007 — Tue, 10 Mar 2015 11:50:58 GMT

PFA. Hope it will help.

Anonymous — Tue, 10 Mar 2015 12:01:16 GMT

Hi Villyee,

You will have to create data like below.

Then use below code.

Hier:

HIERARCHY(leaf Node, PARENT node, leaf description)

LOAD leaf Node,

PARENT node,

leaf description

FROM source file);

Then u can use ur leaf description field in the list box to show hierarchy.

Go through Hierarchy fuction in the reference manual.

Thanks,

NIshant

maleksafa — Tue, 10 Mar 2015 12:01:24 GMT

look for hierarchy load, you can find plenty of posts on the community.