Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asmithids
Partner - Creator II
Partner - Creator 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. 

4 Replies
hic
Former Employee
Former Employee

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

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

HIC

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

asmithids
Partner - Creator II
Partner - Creator II
Author

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

danimarc12
Partner - Creator
Partner - Creator

Hello rwunderlich,

I've followed your guide but I still have an issue in my model... It seems that my "Month" dimension (which is "Mese") is not working. 

I've showed in 3 Pivot tables my situation. Could you have a look please?

Thank you!