Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to join two dates to calendar date?


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.

2 Replies
Not applicable
Author