Hierarchy in QlikView

[vanderson009]

Hi guys,

I want to create employee hierarchy and i have data like

EmployeeId	TeamLeadId	ManagerId	EmployeeName
AA0001			Employee1
AA0002		AA0001	Employee2
AA0003		AA0001	Employee3
AA0004	AA0002	AA0001	Employee4
AA0005	AA0002	AA0001	Employee5
AA0006	AA0003	AA0001	Employee6

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]

Hi ,

Go through below threads .may be helpful for you .

http://community.qlik.com/message/419408#419408

http://community.qlik.com/message/505948#505948

[senpradip007]

PFA. Hope it will help.

[Anonymous]

Hi Villyee,

You will have to create data like below.

leaf node	Parent
AA0001
AA0002	AA0001
AA0003	AA0001
AA0004	AA0002
AA0005	AA0002
AA0006	AA0003

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]

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