Multiple Dates need to create master Calendar

Anonymous — Tue, 16 Dec 2014 19:31:55 GMT

Hi All,

With attached QlikView data Model I need to create a Master calendar with the qvw

I am having 5 tables. In the data model 3 tables joins based on single key. Rest of the tables joins normally.

So here how can I take all the date fields ( Having Creation Date & Updation date) in the Master calendar.

Note:

I am already having Master Calendar script,all I need is how to link all of this Date fields together with Master calendar

For PE users

Domain:

LOAD * INLINE [Domain_Name,DOM_ID,CREATION_TIME1,UPDATION_TIME1

AA,101,15-12-2014,16-12-2014

BB,102,10-11-2014,15-12-2014

CC,103,15-11-2014,18-12-2014

];

Services:

LOAD * INLINE [DOM_ID,Service_Name,Service_Unique_id,CREATION_TIME_2,UPDATION_TIME2

101,S1,11,11-12-2014,22-12-2014

103,S2,13,22-10-2014,25-11-2014

];

Version:

LOAD * INLINE [Service_Unique_id,Version_Name,SLD_Unique_Id,CREATION_TIME3,UPDATION_TIME3

S1,V1,SLD1,15-11-2013,14-12-2013

];

SLA:

LOAD * INLINE [SLD_Unique_Id,SLA_UId,CREATION_TIME4,UPDATION_TIME5

SLD1,SLA1,15-11-2013,1-1-2014

SLD2,SLA2,13-08-2014,11-11-2014

];

SLD:

LOAD * INLINE [SLD_Unique_Id,E_ID,CREATION_TIME,UPDATION_TIME

SLD1,E1,11-11-2013,25-01-2014

SLD2,E2,25-11-2014,25-01-2014

SLD3,E3,11-12-2014,25-01-2014

Re: Multiple Dates need to create master Calendar

Wed, 31 Dec 2014 13:09:47 GMT

You can get help from this website about how to create Master Calendar

www.qlik4life.com/master-calendar-creation-in-qlikview/

Thanks

Harshul