Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following:
LIB CONNECT TO 'Production Head Count';
LOAD EmpNum,
Emplname,
Empfname,
RegTemp,
JobType,
EmpType,
RptMgr,
orgGroup1,
orgName,
Country,
City,
Email,
Coeuser;
SQL SELECT EmpNum,
Emplname,
Empfname,
RegTemp,
JobType,
EmpType,
RptMgr,
orgGroup1,
orgName,
Country,
City,
Email,
Coeuser
FROM HCT.dbo."Emp_Data"
The RptMgr is the EmpNum of the manager..
I would like to link it back to the table to get the EmplName for the manager.
I know in Microsoft Access I would just duplicate the table and join RptMgr to the EmpNum.
How might that be done in Qliksense?
What you need to use is the apply map function this Article will help you understand its use.
https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Regards
Andy
What you need to use is the apply map function this Article will help you understand its use.
https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Regards
Andy
If there's more than two hierarchy levels, use: Loading hierarchy data ‒ Qlik Sense
Tomasz