topic Re: Re: Hierarchy VACANT Positioning in Tree in QlikView

Hierarchy VACANT Positioning in Tree

aveeeeeee7en — Thu, 24 Apr 2014 05:30:47 GMT

Hi Community

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

Regards

Aviral

SergeyMak — Thu, 24 Apr 2014 06:30:20 GMT

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

aveeeeeee7en — Thu, 24 Apr 2014 06:39:59 GMT

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 — Thu, 24 Apr 2014 06:45:56 GMT

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';

aveeeeeee7en — Thu, 24 Apr 2014 07:00:58 GMT

Thanks Sergey

It Works.