Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

how to use single single calendar for two different tables ?

Capture.PNG

2 Solutions

Accepted Solutions

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

MVP & Luminary
MVP & Luminary

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

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

Creator II
Creator II

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

MVP & Luminary
MVP & Luminary

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

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

MVP & Luminary
MVP & Luminary

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