Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

how to use single single calendar for two different tables ?

Capture.PNG

2 Solutions

Accepted Solutions
avinashelite

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

6 Replies
venkat1
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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