comparing value and create matching record as dimesion qliksense

[Aspiring_Developer]

Hello Everyone,

I have below scenario:-

I have three columns coming from the same table :-

Now , my requirement is i have to create a new dimension named as 'Manager ' that show this kind of details like below in a table :-

manager	Person name

Do i need to perform a self join for this ? Can anyone please help me ?

[menta · Accepted solution]

You can use Hierarchy

https://help.qlik.com/it-IT/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes...

or you can made by mapping load loading id and Personname and applymap on the id or you can load 2 times the table with a left join on the details table

[Aspiring_Developer]

Hi @menta  

Thanks for your help.

I was able to do it with the help of apply map .