Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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.
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;
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.
1) How you have created Master Calendar....?
2) StartDate and EndDate both are for each line?
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
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 !!
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