SELF jOIN IN QLIKVIEW

Tue, 24 Jul 2012 05:09:41 GMT

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.

Re: SELF jOIN IN QLIKVIEW

Tue, 24 Jul 2012 07:00:18 GMT

Hi,

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

regards

topic Re: SELF jOIN IN QLIKVIEW in QlikView

SELF jOIN IN QLIKVIEW

Re: SELF jOIN IN QLIKVIEW