Solved: Based on Id display the name - Qlik Community

Ramu_i · ‎2022-05-12

Hi All,

I have data like name, ID and MGR ID .

here based on MGR id display the MGR Name.

Could you please help on that.

Input:

Required Out Put:

Thank you.

Ram

vinieme12 · ‎2022-05-13

As below

Main:
Load * Inline [
EMPID,Name,MGRID
1,Ram,2
2,Raj,4
3,Rani,2
4,Ravi,6
5,Roja,2
6,Rajesh,2
7,Raghu,2
8,Ramyya,6
9,Radha,6
10,Rangha,6
];

Left Join(Main)
Load EMPID as MGRID,Name as MGRNAME
Resident Main;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

vinieme12 · ‎2022-05-13

As below

Main:
Load * Inline [
EMPID,Name,MGRID
1,Ram,2
2,Raj,4
3,Rani,2
4,Ravi,6
5,Roja,2
6,Rajesh,2
7,Raghu,2
8,Ramyya,6
9,Radha,6
10,Rangha,6
];

Left Join(Main)
Load EMPID as MGRID,Name as MGRNAME
Resident Main;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

vinieme12 · ‎2022-05-13

You can also explore

Hierarchy

HierarchyBelongsTo

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Ramu_i · ‎2022-05-13

Hi Vinieme,

It's working .

Thanks

Ram

Based on Id display the name