Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
This would be very helpful
http://min-maxing.com/blog/2012/07/20/easy-date-range-selection-with-qlikview/