how to use single single calendar for two different tables ?

[venkat1]

[venkat1]

By Single Date i need to show both Goldsales,Diasales at a time.

[avinashelite]

Create an master calendar and link the date columns of your tables to the master calendar in this way you can have a common date

[venkat1]

Fields for the dates are different ,so how can i use the master calendar ?

[rwunderlich]

Take a look at this tutorial and downloadable example: 

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[avinashelite · Accepted solution]

simple ..just have a common name for of your date columns and the Master calendar ..that will get the desired results.

[rwunderlich · Accepted solution]

Also, if you don't need to select one date field or the other, just rename field D.Date to to Date and the tables will link.

-Rob