Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Damarlavenkatesh
Contributor

how to use single single calendar for two different tables ?

Capture.PNG

2 Solutions

Accepted Solutions

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.

MVP & Luminary
MVP & Luminary

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
Contributor

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

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

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
Contributor

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 ?

MVP & Luminary
MVP & Luminary

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

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.

MVP & Luminary
MVP & Luminary

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