Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

madushanfernand
New Contributor III

Master Calendar Link To Multiple Dates

Hi All

Please find my Table structure as follows. i have created a master calendar within the range of min and max using four date fields in below four tables. what my concern is i want to link the date in master calendar to all four tables BudgetedSalesDate, ProjectionSalesDate, ConfirmedSalesDate and ActualSalesDate to filter the data as per the selection of Date, Year, Month or Week in Master calendar.

Can any one please suggest me a way to solve this.?

Thank you

Capture.JPG

4 Replies
dilipranjith
Valued Contributor II

Re: Master Calendar Link To Multiple Dates

jayanttibhe
Contributor II

Re: Master Calendar Link To Multiple Dates

I think you need to have a look in it :

TUTORIAL - USING COMMON DATE DIMENSIONS

Search Recipes | Qlikview Cookbook

madushanfernand
New Contributor III

Re: Master Calendar Link To Multiple Dates

Thanks a lot both of you. those example explained the situation precisely.

dilipranjith
Valued Contributor II

Re: Master Calendar Link To Multiple Dates

good to hear. Please close the thread if no further queries

Community Browser