topic Re: Common Calendar in QlikView

Common Calendar

Thu, 16 Jul 2015 06:02:20 GMT

Hello All..

Need Help please..!!

I have a table for the shipment details.In the same table i have arrival date,Load date and also sail date; How can i make a common calendar out of this ??

Please suggest..

Thanks

Reena

Re: Common Calendar

arulsettu — Thu, 16 Jul 2015 06:03:46 GMT

concatenate all the dates togeather

Re: Common Calendar

amit_saini — Thu, 16 Jul 2015 06:04:28 GMT

Hi,

Hope this will help u:

https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Thanks,
AS

Re: Common Calendar

MK_QSL — Thu, 16 Jul 2015 06:08:15 GMT

You need to create a Canonical Date. Use the link provided by amit.saini

Re: Common Calendar

krishna20 — Thu, 16 Jul 2015 06:17:24 GMT

Hi,

Canonical Calendar will works for this scenario perfectly.

Re: Common Calendar

avinashelite — Thu, 16 Jul 2015 12:12:36 GMT

you can create a link tables for the same and finally you can connect them for the master calendar.

EG:

t1:

Load order date,

Purchase date,

from table;

load id,

order date as date

resident

t1;

load id,

Purchase date as date

resident

t1;

Master_calendar:

Load date

from...

Re: Common Calendar

Thu, 12 Jan 2017 10:54:47 GMT

Hi Avinash,

So from where we need to load date for 'Master_calendar:' ? And what variable should be used in filters and dimensions ?

-James