topic Re: comparing value and create matching record as dimesion qliksense in App Development

comparing value and create matching record as dimesion qliksense

Aspiring_Developer — Tue, 20 Jul 2021 07:49:44 GMT

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 ?

Re: comparing value and create matching record as dimesion qliksense

menta — Tue, 20 Jul 2021 07:58:42 GMT

You can use Hierarchy

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

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

Re: comparing value and create matching record as dimesion qliksense

Aspiring_Developer — Tue, 20 Jul 2021 08:07:01 GMT

Hi @menta

Thanks for your help.

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