topic Re: common calender for 3 different dates in QlikView

common calender for 3 different dates

chinnuchinni — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: common calender for 3 different dates

shraddha_g — Tue, 07 Nov 2017 05:11:03 GMT

can create a link table using these 3 tables

Re: common calender for 3 different dates

jonathandienst — Tue, 07 Nov 2017 05:57:20 GMT

This post covers the ways of handling your scenario:

Canonical Date

Re: common calender for 3 different dates

rwunderlich — Wed, 08 Nov 2017 17:35:44 GMT

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

Re: common calender for 3 different dates

vvira1316 — Wed, 08 Nov 2017 17:44:06 GMT

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