Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.
Contributor II

Master Calendar with Two Fact Tables


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

Re: Master Calendar with Two Fact Tables

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



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.




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