Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
Damarlavenkatesh
Not applicable

how to use single single calendar for two different tables ?

Capture.PNG

2 Solutions

Accepted Solutions
avinashelite
Not applicable

Re: how to use single single calendar for two different tables ?

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

rwunderlich
Not applicable

Re: how to use single single calendar for two different tables ?

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

6 Replies
Damarlavenkatesh
Not applicable

Re: how to use single single calendar for two different tables ?

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

avinashelite
Not applicable

Re: how to use single single calendar for two different tables ?

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

Damarlavenkatesh
Not applicable

Re: how to use single single calendar for two different tables ?

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

rwunderlich
Not applicable

Re: how to use single single calendar for two different tables ?

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
Not applicable

Re: how to use single single calendar for two different tables ?

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

rwunderlich
Not applicable

Re: how to use single single calendar for two different tables ?

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