Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

hopkinsc
Not applicable

help with linking master calendar to multiple dates across multiple tables

Hi all,

i have a variety of different dates across multiple tables. i want to link them all to a master calendar but i am struggling to do it. i have tried creating a calendar per table then linking those to a master calendar but i cant seem to get it working.

is anyone able to suggest anything?

i have attached a sample.

many thanks

4 Replies
marcus_sommer
Not applicable

Re: help with linking master calendar to multiple dates across multiple tables

Have a look here: Canonical Date.

- Marcus

balrajahlawat
Not applicable

Re: help with linking master calendar to multiple dates across multiple tables

bill_markham
Not applicable

Re: help with linking master calendar to multiple dates across multiple tables

I have been working on a model with multiple dates using the blog post Canonical Date.suggested above by Marcus and have found it very useful.

sorrakis01
Not applicable

Re: help with linking master calendar to multiple dates across multiple tables

Hi,

I created an example qvw using technical Canonical Date. First the quality of your data is poor and I use Campaign_ID to Primary Key, and don't Load rows if Campaign_ID doesn't exists. I used start_date to Principal Date and only is an idea.

The filters on list box always show the first value column of Table Box.

Repeat, it's only an idea of structure but the data is not correct.

Regards,