data model

[Chanty4u]

hi all,

am new to qliksense...i hve qvd's i need to build datamodel.

i hve below qvds ..

please help me on this..

[Anonymous]

You can drag and drop these QVDs into Qliksense and design the DataModel in the same as you do in QV.

After drag and drop go to script level, do the transformation and create the data model.

[Chanty4u]

thnks got the data model...

and i need to dispaly in barchart actual weekly,

plan weekly,

fsct weekly...for that wat can i do?

[Anonymous]

Did not get you?

Week you can create at script level.

[Chanty4u]

LOAD

    PROJ_ID,

//    PROJ_SHORT_NAME,

  //  DESCRIPTION,

    TASK_CODE ,

    //TASK_NAME,

    RSRC_NAME,

    RSRC_SHORT_NAME,

    STARTDATE,

    Date(STARTDATE) as Sdate,

    WeekEnd(STARTDATE) as WeekEndDate,

    ENDDATE,

    ACTUALUNITS,

    PARENT_RSRC_NAME

//   TASK_ID

FROM [lib://Qvdsource/p6_actuals_RSRC_SPREAD.qvd]

(qvd);

Concatenate

LOAD

    PROJ_ID,

    //PROJ_SHORT_NAME,

    //DESCRIPTION,

    TASK_CODE,

    //TASK_NAME,

    RSRC_NAME,

    RSRC_SHORT_NAME,

    STARTDATE,

     Date(STARTDATE) as Sdate,

    WeekEnd(STARTDATE) as WeekEndDate,

    ENDDATE,

    REMAININGUNITS

FROM [lib://Qvdsource/p6_forecast_rsrc_spread.qvd]

(qvd);

concatenate

LOAD

    PROJ_ID,

    //PROJ_SHORT_NAME,

    //DESCRIPTION,

    TASK_CODE ,

    //TASK_NAME,

    RSRC_NAME,

    RSRC_SHORT_NAME,

    STARTDATE,

     Date(STARTDATE) as Sdate,

    WeekEnd(STARTDATE) as WeekEndDate,

       ENDDATE,

    PLANNEDUNITS

FROM [lib://Qvdsource/p6_planned_RSRC_SPREAD.qvd]

(qvd);

LOAD

    PROJ_ID,

    WBS_PROJ_ID,

    PM_PROJ_ID,

    PROJECT_NUMBER,

    PLAN_START_DATE,

    PLAN_END_DATE,

    PRIM_PROJ_DESCRIPTION,

    CONST_MANAGER_CODE,

    CONST_MANAGER_NAME,

    FACILITY_CODE,

    FACILITY_NAME,

    PROJECT_TYPE_CODE,

    PROJECT_TYPE_NAME,

    ORGANISATION_CODE,

    ORGANISATION_NAME,

    PROJ_MANAGER_CODE,

    PROJ_MANAGER_NAME,

    YARD_MANAGER_CODE,

    YARD_MANAGER_NAME,

    HR_MANAGER_CODE,

    HR_MANAGER_NAME,

    BUSINESS_UNIT_CODE,

    BUSINESS_UNIT_NAME,

    PROJECT_STATUS_CODE,

    PROJECT_STATUS_NAME

FROM [lib://Qvdsource/P6_PROJECT_DETAILS_V.qvd]

(qvd) ;

LOAD

    TASK_ID,

   // PROJ_ID,

    PROJ_SHORT_NAME,

    PROJECT_DESCRIPTION,

    TASK_CODE,

    TASK_NAME,

    TARGET_START_DATE,

    TARGET_END_DATE,

    PHYS_COMPLETE_PCT,

    PROD_SUPERVISOR_CODE,

    PROD_SUPERVISOR_NAME,

    DISCIPLINE_CODE,

    DISCIPLINE_ID,

    DISCIPLINE_NAME,

   // FACILITY_CODE,

    //FACILITY_NAME,

    LOCATION_CODE,

    COST_CODE,

    BASE_START_DATE,

    BASE_END_DATE

FROM [lib://Qvdsource/p6_Task_Details_V.qvd]

(qvd);

dis is my script

[Anonymous]

Which date you are using for your MAster Calender?

There are so many week() function combination. As per your requirement you can create week on your Transction date or master date.

week(TransactionDate) as Week like this

[ogster1974]

Add a new field in your data model to identify your dates as either ACTUAL/PLAN/FORECAST on load.

Then you can use set analysis to identify the different date types when creating your charts.

e.g. COUNT(<DateType={'FORECAST'}>TASK_CODE) To extract your number of tasks forecast to be completed in a given week.

Hope this makes sense

Regards

Andy

[Chanty4u]

thanks andy.& balrajahlawat  

Please help me on this...thanks

.

but i hve created datamodel and ...but i need
to dispaly in barchart accumalate vlues and same in pivot table.....

Please chk attached qvf file and exact requirment in image..i hve tried bt i didnt get..

Please help me out thanks in advance

suresh

[Chanty4u]

any one can do on qlikview is also very helpful to me...

Please look into this...

[ogster1974]

here's a start.  might be some issues with your data as percentage looking weird.