Discussion Board for collaboration related to QlikView App Development.
simple ..just have a common name for of your date columns and the Master calendar ..that will get the desired results.
View solution in original post
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.
By Single Date i need to show both Goldsales,Diasales at a time.
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
Fields for the dates are different ,so how can i use the master calendar ?
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/