Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nsnybs21qv
New Contributor II

Employee Relationship Data

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
1 Solution

Accepted Solutions

Re: Employee Relationship Data

Read about Hierarchy here:

Hierarchies

Hierarchy in QlikView

1 Reply

Re: Employee Relationship Data

Read about Hierarchy here:

Hierarchies

Hierarchy in QlikView

Community Browser