Hierarchy Load

Fri, 06 May 2011 19:38:52 GMT

I am trying to create a hierarchy load to create Tree View of an employee hierarchy but it is not working. I have tried numerous order of load. I have looked at a few examples and this seems to be the correct layout. 'EmployeeTree' is never displayed as a list box item. I have tried making the other fields a 'Tree View' and this has not worked either.

ParentEmployeeBusinessEntityID and SalesRep_ID both are num fields.

Employee:
LOAD 
    DepartmentName,
    num(EmployeeBusinessEntityID) AS SalesRep_ID, 
    (LastName & ',' & FirstName & '.' & MiddleName) AS employee_fullName,
    EndDate AS EmployeeEndDate,
    FirstName AS EmployeeFirstName,
    LastName AS EmployeeLastName,
    MiddleName AS EmployeeMiddleName,
    ParentEmployeeBusinessEntityID,
    StartDate AS EmployeeStartDate,
    Title AS EmployeeTitle;
SQL SELECT *
/*Load hierarchy*/
EmployeeTreeView:
  Hierarchy (ParentEmployeeBusinessEntityID, SalesRep_ID, employee_fullName,, employee_fullName, EmployeeTree) 
  LOAD
  ParentEmployeeBusinessEntityID,
  SalesRep_ID,
  employee_fullName
RESIDENT Employee;
DROP TABLE EmployeeTreeView;

Any suggestions?

Thanks.

topic Hierarchy Load in QlikView

Hierarchy Load