Multiple Calendars and data aggregation - how do I unite data from fields split between two calendars?

[#1]

My primary fact table contains two dates, the "Ticket Created Date" and "Ticket Resolved" date.  I used the script found here:  Creating A Master Calendar

to build my calendar.  As it stands I now have two calendars:

I have two problems:

1. Is there some way to create a single calendar so I can select from both tables by year/month/week/date at the same time?

2. When I add two dimensions to a chart so I can display created and resolved tickets side by side for year/month/week/day, the chart only shows a resolved count for tickets opened in that month, not all tickets resolved that month.

I've tried playing around with various variables to try and pull info from the resolved table but cannot seem to get it right.

Any suggestions?

[maxgro · Accepted solution]

maybe here

Linking to two or more dates

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