Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sureshqv
Esteemed Contributor III

data model

hi all,

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

i hve below qvds ..

please help me on this..

29 Replies
balrajahlawat
Esteemed Contributor

Re: data model

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.

sureshqv
Esteemed Contributor III

Re: data model

thnks got the data model...

and i need to dispaly in barchart actual weekly,

plan weekly,

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

balrajahlawat
Esteemed Contributor

Re: data model

Did not get you?

Week you can create at script level.

sureshqv
Esteemed Contributor III

Re: data model

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

balrajahlawat
Esteemed Contributor

Re: data model

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
Honored Contributor II

Re: data model

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

sureshqv
Esteemed Contributor III

Re: data model

thanks andy.&

.

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

sureshqv
Esteemed Contributor III

Re: data model

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

Please look into this...

ogster1974
Honored Contributor II

Re: data model

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