
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You need canonical date.
https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think you need to have a look in it :
TUTORIAL - USING COMMON DATE DIMENSIONS

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot both of you. those example explained the situation precisely.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
good to hear. Please close the thread if no further queries

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Please Accepts as Solution if it solves your query.
