Linked Calendar

[#1]

Hi all,

I'm trying to create a Calendar (Year, Month, Quater) for grouping on both Product and Customer tables. How can I do so without causing a circular? Thank you for your assistance.

bitegue

[luis_pimentel]

Actually, in your scenario, you will need two master calendars, one for products and other for customers.

Take a look to this post about how to implement a master calendar:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

[#3]

try attached screen shot

[#4]

Thanks Luis, very helpful indeed.

[#5]

Thank you Nagaraj. But I'm not so worried on the Master Calendar from Date (onTransactions). I was actually trying to see if I could create a common Calendar for both Product and Customer?

kind Regards.

[Michiel_QV_Fan · Accepted solution]

I think you need this:

http://robwunderlich.com/storage/qvtutorial/QvTutorial_CommonDateDimension.qvw

[#7]

Many thanks Michiel !!!