Master Calendar

Wed, 20 Jan 2016 15:15:34 GMT

Hello,

Is it possible to create a master calendar based on multiple fields within multiple tables. For example, I have five tables (A, B, C, D, E). A and B are linked based on their Customer ID. C and D are linked together based on their Order No. D and E are linked together on PersonID but C and D aren't linked at all to A, B and C. (They are separate but I would like them to be shown on the same report). Within the tables there are a variety of fields that contain dates that I would like to link to one Master Calendar.

Table A	Table B	Table C	Table D	Table E
CustomerID	CustomerID	Order No	PersonID	PersonID
Allocation	Date Entered	Date Entered	Name	Address1
TransactionDate	Order No	Part	Nationality	Address2
Last Login Date		Cost	Date of Birth	Post Code
			Birth Town	Date Joined

Is it possible to have one Master Calendar so that if I chose the year '2016' I can see Transactions and Logins from Table A, Customers Entered from Table B. Orders Entered (Date Entered) from Table C, anyone born in 2016 (Date of Birth) from table C, or anyone that joined (Date Joined) in 2016.

Thanks in advance

Re: Master Calendar

marcus_sommer — Wed, 20 Jan 2016 16:47:19 GMT

You might need to create several calendars - have a look here: How to use - Master-Calendar and Date-Values on the link of Canonical Date.

- Marcus

topic Re: Master Calendar in QlikView

Master Calendar

Re: Master Calendar