topic Re: master calender linking in QlikView

master calender linking

surajap123 — Wed, 30 Apr 2014 15:17:06 GMT

Hi All,

I have startdate and enddate in my fact table. I have generated master calender using startdate and enddate fields in the fact table.

I am not sure how can i connect the DATE field generated in the master calender to the fact table as you know the fact table contain 2 date columns ie startdate and enddate.

Regards,

Suraj

Re: master calender linking

MK_QSL — Wed, 30 Apr 2014 15:18:46 GMT

Final Date of your master calendar should be renamed as per your fact table date..

i.e. [invoice date] or [purchase date]

So, QlikView script will automatically make association between your master calendar and your fact table due to common field name.

Re: master calender linking

its_anandrjs — Wed, 30 Apr 2014 15:23:52 GMT

On the basis on one date field you can connect like but at a time only one

Fact:

Load

startdate as DATE //But you have to confirm from which date you have to connect.

From Source:

MasterCalendar:

Load

DATE

From Location;

Re: master calender linking

surajap123 — Wed, 30 Apr 2014 15:27:04 GMT

Hi Manish,

There are 2 date fields in fact table (ie StartDate and EndDate) of the Booking.

I know that i can rename the field to link the master calender with fact table, but there are 2 date fields.

Re: master calender linking

MK_QSL — Wed, 30 Apr 2014 15:30:23 GMT

1) How you have created Master Calendar....?

2) StartDate and EndDate both are for each line?

Re: master calender linking

Wed, 30 Apr 2014 15:48:58 GMT

handling multiple dates in fact tables is purely based on what is your requirement. check this great post by HIC

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Re: master calender linking

surajap123 — Wed, 30 Apr 2014 15:55:11 GMT

I also have a single date field in my fact table, which is the booking date. I connected the master calender to that field.

Thanks a lot for the inputs !!

Re: master calender linking

richard_pearce6 — Tue, 27 May 2014 16:06:01 GMT

For anyone who needs a Calendar - Here's a 'AsOf' Calendar script which makes set analysis very simple.

http://community.qlik.com/docs/DOC-6593

Regards

Richard

QlikCentral.Com