Common Calendar

[#1]

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

[arulsettu]

concatenate all the dates togeather

[amit_saini]

Hi,

Hope this will help u:

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

Thanks,
AS

[MK_QSL]

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

[krishna20]

Hi,

Canonical Calendar  will works for this scenario perfectly.

[avinashelite]

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,

     id

from table;

load id,

     order date as date

resident

t1;

load id,

     Purchase date as date

resident

t1;

Master_calendar:

Load date

from...

[#7]

Hi Avinash,

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

-James