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

Wed, 24 Sep 2014 19:48:15 GMT

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?

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

maxgro — Wed, 24 Sep 2014 20:22:22 GMT

maybe here

Linking to two or more dates

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

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

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

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