Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
This is useful thank you Rob