topic Re: Hierarchy Question in QlikView

Hierarchy Question

aveeeeeee7en — Wed, 23 Apr 2014 18:10:21 GMT

Hi Community

Kindly see the Attached QVW.

I have mentioned my requirement there as per the Example

Regards

Aviral

Re: Hierarchy Question

Anonymous — Wed, 23 Apr 2014 18:37:45 GMT

add the load statement below above your first load and replace the old column with the new one in your hierarchy load.

Emp:

LOAD *,
     if([Reporting To]='VACANT',DivisionalHead, [Reporting To]) as [Reporting To New];
LOAD EmpID,
     Name,
     Department,
     [Reporting To],
     emp_code,
     emp_location,
     MANAGER_POSN,
     DivisionalHead
FROM TESTDATA.qvd(qvd);

Hierarchy:
Hierarchy (EmpID,[Reporting To New],Name,Manager,Name,EmpTree,'/',Level)
LOAD *
RESIDENT Emp;
DROP TABLE Emp;

Re: Hierarchy Question

aveeeeeee7en — Wed, 23 Apr 2014 18:45:08 GMT

Thank You Jsaradhi

Your Logic is working Perfectly

But I also want the MANAGER_POSN to be used in the Code.

In my example, there is one Manager who is blank but in future if there are 2 or more null than i identify with MANAGER_POSN.

Re: Hierarchy Question

Anonymous — Wed, 23 Apr 2014 19:03:27 GMT

just modify the load statements to something like:

LOAD *,
//     if([Reporting To]='VACANT',DivisionalHead, [Reporting To]) as [Reporting To New],
if([Reporting To]='VACANT',SubField(link1,'_',1),[Reporting To]) as [Reporting To New],
   if([Reporting To]='VACANT',SubField(link1,'_',2),MANAGER_POSN) as MANAGER_POSN_New;
LOAD EmpID,
     Name,
     Department,
     [Reporting To],
     emp_code,
     emp_location,
     MANAGER_POSN,
     DivisionalHead,
     DivisionalHead&'_'&MANAGER_POSN as link1

FROM
TESTDATA.qvd
(qvd);

of course, now MANAGER_POSN_New and [Reporting To New] should be the fields you use. you can even drop the older fields at the end of the script if necessary.

Re: Hierarchy Question

aveeeeeee7en — Wed, 23 Apr 2014 19:38:50 GMT

Thank You Very-2 Much for the Solution and devoting your time on this issue.

Regards

Aviral

Re: Hierarchy Question

Anonymous — Wed, 23 Apr 2014 19:56:06 GMT

np. good luck.