Every time when i start work on QV project i get this issue of linking my Master Calendar with dates available in multiple tables.
This time i need to understand it correctly.
I have date field in 3 different tables and I have a Master calendar. I need to link date fields from 3 tables with Master Calendar date field.
Appreciate any guidance on this and explanation.
It is no harm if you load multiple Calendar's. However, it depends on your other data tables and the link between them.
You can create on Calendar this fields:
- Date as DateTable1
- Date as DateTable2
- Date as DateTable3
and then you have related each Table with Calendar
See this example for a tutorial:
Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/
Hi Poonam, Any solution to this question.. i have a similar issue
My closest analysis came from this link Canonical Date
Kindly let me know if there is a way where we can get away with one table only for dates
Hi Rob, Thankyou this works for me in most charts.
In one chart however i see a problem in sorting. Using the field 'Month' from the table common calendar i am unable to sort my x axis
Rob, These are month fields, in the format Jul - 2017, Jun - 2017 ....
Numerically is does not sort
The dimension is having the expression =month(DateMaturity)&'-'&year(DateMaturity)
Thanks for the help so far
Thanks for the sharing. May I know if you have the solution as well, if within the same table I have multiple date fields?
Is it possible to link them to the same Master Calendar?
Thanks & Regards,