1 Reply Latest reply: Nov 9, 2010 9:54 AM by Roland Kunle RSS

    how to select different data?

      hi friends,

      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):

      error loading 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):

      error loading image

      error loading image

      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):

      error loading image

      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:

       

       

      DeliverableInternalSubcontractor:

      LOAD IDMyDeliverable,

      IDMyProject,

      IDMyProjectDeliverable,

      DeliverableIntSubcontractorName,

      DeliverableInternalSubcontract

      FROM

      C:\Test_DataSource_for_QlikView.xls

      (biff, embedded labels, table is DeliverableIntSubcontractor$);


      DeliverableMainContractor:

      LOAD IDMyDeliverable,

      IDMyProject,

      IDMyProjectDeliverable,

      DeliverableMainContractorName

      FROM

      C:\Test_DataSource_for_QlikView.xls

      (biff, embedded labels, table is DeliverableMainContractor$);