I have QlikView project where I'm selecting data about my projects:
- project name, start date, end date, ...
- each project has some number of deliverables, each deliverable has start date, end date, total invoice on deliverable, ...
- on each deliverable can participate main contractor (named group of employees), internal subcontractor (other named group of employees) and/or external subcontractor (some external company)
In QlikView project I can pick up some date interval (eg.year: 2010, month: February) and all related projects are visible (see following image):
Each "Group" (named group of employees) may be as main contractor (=main implementator of deliverable/project), or it may be as internal subcontractor (for example: for PROJECT id=29 is main contractor is GROUP B and internal subcontractor is GROUP A (see following images):
And now I want to display (after selecting some group) all projects where eg.GROUPB is main contractor (in straight table on top of QlikView project sheet) and rest projects where GROUPB is internal subcontractor (see straight table on bottom of sheet):
but I have some different view in table on bottom!
In PROJECT29 is main contractor GROUPB (in all 3 deliverables) and internal subcontractor is GROUPA (only in deliverable P29-01) (please compare with images of data).
I would want to display: - top table is OK, - bottom table has to display all projects where GROUPB is internal subcontractor
For detail information I have following load script:
(biff, embedded labels, table is DeliverableIntSubcontractor$);
(biff, embedded labels, table is DeliverableMainContractor$);