Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III

Hierarchy VACANT Positioning in Tree

Hi Community

Need to set the Employees in Tree Structure  who have VACANT Manager Name based on the MANAGER_POS

Regards

Aviral

1 Solution

Accepted Solutions
SergeyMak
Partner Ambassador
Partner Ambassador

Ok. No problem. No hard coding

But the same idea

Concatenate (Emp)

LOAD

[Reporting To] AS EmpID,

DivisionalHead AS [Reporting To],

[Reporting To] AS Name,

Department

Resident Emp

WHERE [Reporting To]='VACANT';

Regards,
Sergey

View solution in original post

4 Replies
SergeyMak
Partner Ambassador
Partner Ambassador

Hi Nag,

I think you need to add a raw with VACANT employee

Concatenate (Emp)

LOAD * INLINE [

EmpID, Reporting To, Name, DivisionalHead,Department

VACANT, Sanjeev Sinha,VACANT,Sanjeev Sinha,14 Development Dept.

];

and you don't need if([Reporting To]='VACANT',DivisionalHead, [Reporting To]) as [Reporting To New];

PFA

Regards,
Sergey
aveeeeeee7en
Specialist III
Specialist III
Author

Hi Sergey

Thanks for the Reply but I don't want to do this with Inline function since everytime I don't know who has left the Company.

I don't want this to be done by doing Hard Coding.

Any Other Options???

SergeyMak
Partner Ambassador
Partner Ambassador

Ok. No problem. No hard coding

But the same idea

Concatenate (Emp)

LOAD

[Reporting To] AS EmpID,

DivisionalHead AS [Reporting To],

[Reporting To] AS Name,

Department

Resident Emp

WHERE [Reporting To]='VACANT';

Regards,
Sergey
aveeeeeee7en
Specialist III
Specialist III
Author

Thanks Sergey

It Works.