common calender for 3 different dates

[chinnuchinni]

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

Chinnu

[shraddha_g]

can create a link table using these 3 tables

[jonathandienst]

This post covers the ways of handling your scenario:

Canonical Date

[rwunderlich]

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/

-Rob

[vvira1316]

Hi Praveen,

Following blogs of HIC had been useful to me. One of them has already mentioned by Jonathan Dienst.

The Master Calendar

Canonical Date

I have used it in dashboard development with multiple date fields.

I hope it will be useful to you as well.

BR,

Vijay