Discussion board where members can get started with QlikView.
Hi every one,
I have 3 table which are having 3 different date fields.i need to create a common calendar for those 3 tables with using those 3 dates.can any one please give the suggesion.
Thanks & Regards
can create a link table using these 3 tables
This post covers the ways of handling your scenario:
In addition to the link Jonathan posted, here's a tutorial:
Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/
Following blogs of HIC had been useful to me. One of them has already mentioned by Jonathan Dienst.
The Master Calendar
I have used it in dashboard development with multiple date fields.
I hope it will be useful to you as well.