topic Re: Master Calendar to account for two date fields in a single table? in App Development

Master Calendar to account for two date fields in a single table?

Wed, 15 Mar 2017 02:21:22 GMT

Hello all

I have a fact table that contains two fields [Registration Date] and [Decision Date], how would I create a master calendar to account for both dates?

Any suggestions or solutions would be appreciated

Thanks in Advance

Re: Master Calendar to account for two date fields in a single table?

rwunderlich — Wed, 15 Mar 2017 02:48:32 GMT

Two potential approaches:

Canonical Date

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Master Calendar to account for two date fields in a single table?

Wed, 15 Mar 2017 03:14:22 GMT

I will look into the Canonical Date solution.

Thanks for your help Rob much appreciated!