topic Master Calendar Link To Multiple Dates in QlikView

Master Calendar Link To Multiple Dates

madushanfernand — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Master Calendar Link To Multiple Dates

dplr-rn — Wed, 10 Oct 2018 15:36:56 GMT

You need canonical date.

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

Re: Master Calendar Link To Multiple Dates

jayanttibhe — Wed, 10 Oct 2018 16:20:50 GMT

I think you need to have a look in it :

TUTORIAL - USING COMMON DATE DIMENSIONS

Search Recipes | Qlikview Cookbook

Re: Master Calendar Link To Multiple Dates

madushanfernand — Thu, 11 Oct 2018 09:26:32 GMT

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

Re: Master Calendar Link To Multiple Dates

dplr-rn — Thu, 11 Oct 2018 13:49:59 GMT

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

Re: Master Calendar Link To Multiple Dates

neerajthakur — Mon, 04 Jul 2022 09:46:22 GMT

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