Multiple Dates need to create master Calendar

[Anonymous]

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

[#2]

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

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

Thanks

Harshul