topic Master Calendar from more than one date field in QlikView

Master Calendar from more than one date field

Fri, 22 Aug 2014 08:00:58 GMT

Hi everyone,

I have three tables

Product:

Id	Product	Purchase Date
11	P1	12-01-2013
12	P2	14-05-2012
13	P3	17-08-2013

Supplier:

Id	Product	Invoice Date
11	P1	10-10-2006
12	P2	15-09-2005
13	P3	11-10-2005

Sales

Product	Sales	Purchase Date	Company
P1	200	20-12-2013	Abc
P1	100	01-02-2014	Xyz
P2	150	12-03-2014	Pqr
P3	100	12-01-2014	Abc

now my requirement is to create a single master calendar for all date field. So whenever any date value is selected possible selection is reflected by all three tables. I know the logic to create,I know I need to find the Max date value and Min date value from all three field.But how all three tables will be associated.

Please help me out if anyone has any idea.

Re: Master Calendar from more than one date field

tresB — Fri, 22 Aug 2014 08:03:42 GMT

Read this: http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

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

Re: Master Calendar from more than one date field

sushil353 — Fri, 22 Aug 2014 08:05:17 GMT

Hi,

Create three separate field in mastercalender for each table:

MasterCalender:

load

Date,

Date as Sales.PurchaseDate,

Date as Supplier.InvoiceDate,

Date as Product.PurchaseDate,

Now you can associate each table with corresponding field in master calender