Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jvanlanen
New Contributor

Link Manager ID back to Employee ID

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?

1 Solution

Accepted Solutions
ogster1974
Honored Contributor II

Re: Link Manager ID back to Employee ID

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

2 Replies
ogster1974
Honored Contributor II

Re: Link Manager ID back to Employee ID

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

tomasz_tru
Valued Contributor

Re: Link Manager ID back to Employee ID

If there's more than two hierarchy levels, use: Loading hierarchy data ‒ Qlik Sense

Tomasz