0 Replies Latest reply: Jun 27, 2017 2:32 AM by satish qlik RSS

    org_chart_doubt

    satish qlik

      Hi Everyone,

       

      please help me on below hierarchies script and suggest where i did wrong.

       

      I have a table it has two fields emp ID and reporting Manager ID

       

      now am going to create hierarchy

       

       

       

      temp:

      LOAD Text([Emp No.]) as ID1,

           Text([Reporting Manager Emp ID]) as RM

      FROM

      <>;

       

       

      TreeView:

      LOAD Distinct

      ID1 as Value,

      ID1&'-ID1' as Node_ID,

      RM&'-RM' as Parent_Node_ID

      Resident temp;

       

       

      LOAD Distinct

      RM as Value,

      RM&'-RM' as Node_ID,

      RM&'-RM' as Parent_Node_ID

      Resident temp;

       

       

      HirTable:

      Hierarchy(Node_ID_H,Parent_Node_ID_H,ID,Parent_Name,Name,ORG)

      LOAD

      Value as ID,

      Value as Name,

      Node_ID,

      Node_ID as Node_ID_H,

      Parent_Node_ID as Parent_Node_ID_H

      Resident TreeView;