1 Reply Latest reply: Jul 28, 2016 4:11 PM by Sunny Talwar RSS

    Employee Relationship Data

    Yvonne Han

      Hi


      I need some help with a  HR file with Employee-Manager relationship. The data structure looks like below. What's the best way to reconstruct the organization chart? If I have an employee, how do I find all the people that reports to this person, not just his direct report? I know in SQL, we can do a self join with a recursive query. What's the best way to achieve this in Qlikview?

       

      Thanks

       

      Sample Data:  

      EmployeeManager
      TomN/A
      JamesTom
      JenniferTom
      CaseyTom
      DanaJames
      AllenJames
      LauraJennifer
      SolLaura