Link Date Quarters together

[#1]

Hi,

I have 3 types of Dates data (Bookings, Opportunities and Targets).  I have created a Master Calendar for Bookings so I can segregate the dates into Quarters.  Opportunities and Targets are just fields/table with the actual quarter data (i.e. Q1, Q2).

I want to link them so that when I select the Bookings Quarter, it will automatically show me the Targets for that same quarter as well as the Opportunities.  Is this possible?  Do they all have to be made into Master Calendars?

If i try to call the field names the same name - I get a looping error message.

Thanks for any help.

Cheers.

[ashfaq_haseeb]

Hi,

You can create a master calendar as specified below.

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

Regards

ASHFAQ

[PradeepReddy]

If these 3 dates(Bookings, Opportunities and Targets) are in same table no link is required.

If the 3 dates are in different tables...

1) First find tselect the Min and Max dates among the 3 dates

2) Create a Master Calender with Min of 3 dates and Max of 3 dates

3) Join 3 tables with Master Clander Table

Regards

Pradeep