Personal Info with Hierarchy Table

[rendiyan]

Dear Qlik Developer,

I have a question for personal info with a hierarchy table.

So i have Transaction, Sales, Personal table

Transaction Table Desc :

SalesID	TransID
21	1
32	2
41	3

Sales Table Desc :

ManagerID	SupervisorID	SalesID
1	11	71
1	12	72
2	21	81
2	22	82
3	31	91

Personal Table Desc :

EmpID	Name
1	One
2	Two
3	Three
11	Oneone
12	Onetwo
21	Twoone
22	Twotwo
31	Threeone
71	Sevenone
72	Seventwo
81	Eightone
82	Eighttwo
91	Nineone

Transaction related to Sales based on SalesID.

But in Sales table, i have nested column (Manager -> Supervisor -> Sales).

So my question is, is it possible to make a relationship between Personal table to Sales table?

Thanks,

Best Regards

[Gysbert_Wassenaar]

I think you forgot to ask the question. What is your question?

[miguelbraga]

Hi Rendi,

I'm sorry but I can't understand your question either, can you please elaborate better?

Regards,

MB