Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
try attached screen shot
Thanks Luis, very helpful indeed.
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.
I think you need this:
http://robwunderlich.com/storage/qvtutorial/QvTutorial_CommonDateDimension.qvw
Many thanks Michiel !!!