Calculated field using existing data in row

[mmhw]

Hi!

I have a table looking something like this:

EmployeeId	EmployeeName	ManagerId
1	John Doe	2
2	Jerry Johnson	0
3	Jane Doe	2

Jerry is John and Jane's manager but instead of id, I would like to add a calculated column ManagerName. So something like add EmployeeName from row where EmployeeId = ManagerId. How can I achieve this? I am completely new att Qlik Sense but can't seem to find any answers to this.

Thank you!!

[Kushal_Chawda]

@mmhw  try below

Data:
LOAD EmpID,
     EmpName,
     MgrID
FROM table;

left join(Data)
LOAD EmpID as MgrID,
     EmpName as MgrName,
resident Data;