Discussion board where members can get started with Qlik Sense.
I have the following:
LIB CONNECT TO 'Production Head Count';
SQL SELECT EmpNum,
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?
Go to Solution.
What you need to use is the apply map function this Article will help you understand its use.
If there's more than two hierarchy levels, use: Loading hierarchy data ‒ Qlik Sense