Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Hierarchy roll up questions

Hi experts

I am trying to build an HR hierarchy that i need to know who manages what.

For example I have a list of managers:

MangerIDDepartmentDepartment IDLocationLocationID
1Total Products0World1
123Clothing1USA1011
321Woman's Clothing20World1
213Man's Clothing30Asia1003
312Shoes2North America1000

For Each Employee    

EmployeeIDDepartmentDepartment IDLocationLocation IDHeader 7
456Women's Sweater2025NYC100001
564Boots3075Vancouver 100070
654Men's ties4073Hongkong100084
444underwear252Chicago100045
555Sleepwear111USA1011

I do have the hierarchy for the department and location

Department IDParent ID
202520
201
301
30752
10
407330
252

1

111

1

20
Location ID

Parent Location ID

10111000
10001
100011000
1000841003
1000741000
100045

1000

1000701000
10001

How do I create a model so it rolls up and I can tell who is under the manager given? Or do i need more information to get what i want?

thanks!         

2 Replies
Highlighted
Specialist
Specialist

Up

Highlighted
Partner
Partner

Alex,

I would start with a couple of write ups that hic‌ put together:

Hierarchies

Unbalanced, n-level hierarchies

Good luck!

Oscar