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: 
chinnuchinni
Creator III
Creator 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
shraddha_g
Partner - Master III
Partner - Master III

can create a link table using these 3 tables

jonathandienst
Partner - Champion III
Partner - Champion III

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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

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