SELF jOIN IN QLIKVIEW

[#1]

Hi all,

I need a help regarding the self-join in qlikview I am having a single table as an employee and their reporting manager. Manager details will also in the same table and he will be having manager as other person. What I need to do is if  I select an employee whole hierarchy of manager should be shown. For more understanding see the below example

Employee	Manager
A	B
B	C
C	D
D	E

Here if I select A I should get the relation as A-B-C-D-E.

[#2]

Hi,

take a look to hierarchy statement in Reference Manual. This can be done with it.

regards