Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can get help from this website about how to create Master Calendar
www.qlik4life.com/master-calendar-creation-in-qlikview/
Thanks
Harshul