topic Re: How to join two dates to calendar date? in QlikView

How to join two dates to calendar date?

Tue, 16 Sep 2014 15:33:30 GMT

Hi,

I have three dates and ids in two different tables. please see below and can anyone give me script of how to join these to calendar date?

Table1:
LOAD CustomerID,
     CustomerCode,
     Date(Floor(CustomerLogged)) as CustomerLogged,

FROM
[..\QVD\Data\Table1.qvd]
(qvd);

Table2:
LOAD
     ProcessID,
     CustomerID,
     Date(Logged,'DD/MM/YYYY')                                              as Logged,
     Date(Processed,'DD/MM/YYYY')                                           as Processed

FROM
[..\QVD\Data\Table2.qvd]
(qvd);

Thanks.

Re: How to join two dates to calendar date?

Anonymous — Tue, 16 Sep 2014 15:48:12 GMT

Here is nice explanation with solutions:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

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

Re: How to join two dates to calendar date?

Tue, 16 Sep 2014 17:48:06 GMT

This would be very helpful

http://min-maxing.com/blog/2012/07/20/easy-date-range-selection-with-qlikview/