Master Calendar Link To Multiple Dates

[madushanfernand]

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

[dplr-rn]

You need canonical date.

https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

[jayanttibhe]

I think you need to have a look in it :

TUTORIAL - USING COMMON DATE DIMENSIONS

Search Recipes | Qlikview Cookbook

[madushanfernand]

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

[dplr-rn]

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

[neerajthakur]

I have tried this and results are coming for kpi's but in trend chart for fiscal year I am getting multiple values and for dates which have come yet like 2050-2051