Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
chinnuchinni
Contributor III

common calender for 3 different dates

Hi every one,

I have 3 table which are having 3 different date fields.i need to create a common calendar for those 3 tables with using those 3 dates.can any one please give the suggesion.

Thanks & Regards

Chinnu

4 Replies
Partner
Partner

Re: common calender for 3 different dates

can create a link table using these 3 tables

MVP
MVP

Re: common calender for 3 different dates

This post covers the ways of handling your scenario:

Canonical Date

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP & Luminary
MVP & Luminary

Re: common calender for 3 different dates

In addition to the link Jonathan posted, here's a tutorial:

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob

vvira1316
Valued Contributor II

Re: common calender for 3 different dates

Hi Praveen,

Following blogs of HIC had been useful to me. One of them has already mentioned by Jonathan Dienst.

The Master Calendar

Canonical Date

I have used it in dashboard development with multiple date fields.

I hope it will be useful to you as well.

BR,

Vijay