Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you forgot to ask the question. What is your question?
Hi Rendi,
I'm sorry but I can't understand your question either, can you please elaborate better?
Regards,
MB