topic Issue with Numerous Date Field in App Development

Issue with Numerous Date Field

Tue, 29 Aug 2017 14:52:59 GMT

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.

Re: Issue with Numerous Date Field

rwunderlich — Wed, 30 Aug 2017 00:07:18 GMT

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

Re: Issue with Numerous Date Field

Wed, 30 Aug 2017 09:29:33 GMT

This is useful thank you Rob