Dealing with Multiple Calendars

[#1]

Hey All,

Having some issues with dates.  In one application I have Open date, close date and target date and in another I have just open date and close date.

What I have done thus far is create a master calendar for each, tied directly to the source date in the facts table. 

Is there a better way to handle multiple calendars?

[Anonymous]

Create just a master calendar.

Use QVD. Not generate it inside Edit Script.

[fkeuroglian]

Hi, see this links provided by rob wunderlich

Hope help

Tutorial - Using Common Date Dimensions and Shared Calendars

The Master Calendar

http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

Why You sometimes should Load a Master Table several times

[#4]

Antonio,

Each of the unique dates are important for the application. It is a sales application so we need to compare open and close dates for each deal. For example, if a user were to leave ‘status’ (won, lost, in progress) unclicked, a master calendar would be confusing.

Maybe I should be creating a ‘days to close’ field instead of the close date field and do the calculations in the document? Not even sure how I’d do that.

[yduval75]

Hello,

I thin you can use a link table to link all master calendars.

This article can help you

Canonical Date