topic help with linking master calendar to multiple dates across multiple tables in QlikView

help with linking master calendar to multiple dates across multiple tables

hopkinsc — Wed, 17 Feb 2016 10:36:42 GMT

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

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

marcus_sommer — Wed, 17 Feb 2016 11:12:02 GMT

Have a look here: Canonical Date.

- Marcus

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

Anonymous — Wed, 17 Feb 2016 11:16:45 GMT

Check this, looks similar to your requirement?

Why You sometimes should Load a Master Table several times

Using Multiple Dates With Master Calendar

Linking Master Calendar data to transaction data with multiple dates

Linking to two or more dates

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

Anonymous — Wed, 17 Feb 2016 11:26:26 GMT

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.

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

sorrakis01 — Wed, 17 Feb 2016 17:15:20 GMT

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,