Issue with Numerous Date Field

[#1]

Hello Everyone,

I have 7 unrelated date fields in two tables.

I would like the same flexibility afforded by a master calendar i.e. being able to analyse via day, week, month etc. How would I do this? Would it be best practise to create a master calendar for each field? Or, to amend each field within their original tables?

Sorry if this is vague, I hope you can understand my query.

Here is one of the tables I am referring to. It features the date fields: 

[Date of Receipt]

[First Payment Date]

[Last Payment Date]

[Loan Recipient Birth Year] is also a date field but I don't think it would be necessary for it to be put into a master calendar.

[rwunderlich · Accepted solution]

Take a look at this tutorial:

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

Download the Qlik Sense example by clicking the "S" icon.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#3]

This is useful thank you Rob