Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
asmithids
Partner
Partner

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
Henric_Cronström

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

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
Partner
Author

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

danimarc12
Partner
Partner

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!