Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with Numerous Date Field

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.

Screenshot (105).png

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

This is useful thank you Rob