topic Re: Dealing with Multiple Calendars in QlikView

Dealing with Multiple Calendars

Fri, 12 Dec 2014 16:24:04 GMT

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?

Re: Dealing with Multiple Calendars

Anonymous — Fri, 12 Dec 2014 16:28:11 GMT

Create just a master calendar.

Use QVD. Not generate it inside Edit Script.

Re: Dealing with Multiple Calendars

fkeuroglian — Fri, 12 Dec 2014 16:31:03 GMT

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

Re: Dealing with Multiple Calendars

Fri, 12 Dec 2014 16:33:58 GMT

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.

Re: Dealing with Multiple Calendars

yduval75 — Fri, 12 Dec 2014 16:48:21 GMT

Hello,

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

This article can help you

Canonical Date