Set up Master Calendar with Different Date Fields

[#1]

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

[marcus_sommer · Accepted solution]

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

- Marcus

[m_woolf]

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

Recipes | Qlikview Cookbook

[#4]

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

Best,

Becky