Set Analysis

Fri, 30 Jul 2010 08:10:15 GMT

In a typical organization managers have employee and employee report up to managers.

I have case where an organization has managers who have employee reporting back to them but employees also report to their mentor.

Some employee may have their manger also as mentor.

I have a set analysis question where I am trying to find out whether a manger has all his employee reporting back to them as mentor or not.

I have three tables, and for my own reasons which I can not explain in words, these table columns can not be changes or these tables can not be further merged into lesser no of tables using joins etc.

MGR 1 has 3 employee emp1, emp2, emp3 where emp1 also reports to mtr7 and emp2 reports to mtr8 and emp3 reports back to mgr1.

Case 1:

I start with selecting a manger, that filters down the employees of the manger, that automatically shows employee all managers/mentor they report to.

I am trying to put a Y and N indicator in the third column of table "Unique Or Not", a Y is to be shown when emp reports to manager selected on the "Managers and Mentors In Company" and N will show up when an employee is reporting to a mentor other than manger.

My expected results for case 1 is:

	Unique Or Not
"Managers And Mentors In Company" table selection	Emp1	MGR1	N
MGR1	Emp1	MTR7	N
	Emp2	MGR1	N
	Emp2	MTR8	N
	Emp3	MGR1	Y

Case 2:
I start with selecting a manger (MGR1) and a mentor (MTR7).
In this case emp1 who reports back to MGR1 and MTR7, should have a Y in the third table (Unique Or Not) because emp reports to same set of people as selected in "Managers and Mentors In Company".

Emp3 should say Y also as it reporting to people, though lesser than selected people in "Managers and Mentors In Company".

Emp2 should say N coz it is reporting to MTR8 which is not in selection.

This analysis is to find out whether a group of manager/mentor have all employee reporting back to them.

	Unique Or Not
"Managers And Mentors In Company" table selection	Emp1	MGR1	Y
MGR1 & MTR7	Emp1	MTR7	Y
	Emp2	MGR1	N
	Emp2	MTR8	N
	Emp3	MGR1	Y

Hope I have explained the situation well.

topic Set Analysis in QlikView

Set Analysis