topic Re: Set up Master Calendar with Different Date Fields in QlikView

Set up Master Calendar with Different Date Fields

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have two tabs in a QVW file. Each tab has one date field associate with it. For example, "Order Date" associate with "Order" table, "Receipt Date" associate with "Receipt" table.

Both date fields are very important and is the key to set up with master calendar. I know that a master calendar must be associate with a date field. However, if I set up my master calendar with "Order Date", the date range in my "Receipt" table won't be correct. So I will need to set up a master calendar with more than one date fields. Or is there a way to set up two master calendar with two different dates within the same QVW file?

Thank you for your help in advance!

Becky

Re: Set up Master Calendar with Different Date Fields

marcus_sommer — Mon, 25 Jul 2016 14:26:05 GMT

Have a look here: Why You sometimes should Load a Master Table several times and here: Canonical Date‌.

- Marcus

Re: Set up Master Calendar with Different Date Fields

m_woolf — Mon, 25 Jul 2016 14:28:31 GMT

Download Rob Wonderlich's cookbook recipe for Tutorial - Using Common Date Dimensions:

Recipes | Qlikview Cookbook

Re: Set up Master Calendar with Different Date Fields

Mon, 25 Jul 2016 14:58:06 GMT

Perfect. Thank you Marcus! I will try create different master calendar for each date.

Best,

Becky