Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
asmithbi
Contributor II

Master Calendar with Two Fact Tables

Hello,

Is it possible to create a Master Calendar that can work between two fact tables?  See attached data model.  I have Sales Order and Invoice tables that both contain transaction dates.  I would like to create one Master Calendar that has a Year and Month dimension so I can have a List Box for Year and Month respectively. 

Thank you in advance for any information on this. 

3 Replies
Employee
Employee

Re: Master Calendar with Two Fact Tables

I would have several calendars. And one canonical date for all dates.

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

HIC

Re: Master Calendar with Two Fact Tables

Also see:

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

for a tutorial on handling multiple fact dates.

-Rob

http://masterssummit.com

http://robwunderlich.com

asmithbi
Contributor II

Re: Master Calendar with Two Fact Tables

Thank you Henric and Rob for the information!  I will review all of this documentation. 

Community Browser