Table Join with chronological join

qlikviewaf — Mon, 26 Jan 2026 16:26:21 GMT

Hello everyone!!

I have the following tables

Table1: on this table i would like to be able to add the information about Delivery Number and Delivery Date that are saved on another table (Table 2).

The join from table 2, needs to be done using Item + Location + Lotn and then assign the most recent Delivery Number and Delivery Date to the table 1 - so the rows highlighted in green should be reported in the table1.

Complexity of this, is that if for an item-lot-location i have 2 (or maybe more records, as it is for item B-NewYork-CC12) i have to first assign the most recent value (1239038) and then the less recent value (1928397). It's like a chronological assignemnt.

Does anyone know if this can be achieved with qlikview?

Thanks!!!

Re: Table Join with chronological join

BrunPierre — Thu, 01 Sep 2022 21:56:26 GMT

Using the first four records in Table2 to exemplify

Table1: load * From Table1; Table2: Load * Inline[ ITEM,LOCATION,LOTN,DELIVERY NUMBER,DELIVERY DATE A,SYDNEY,AKJI202,12890,10/01/2022 B,NEW YORK,CC12,13190,12/01/2022 B,NEW YORK,CC12,13490,14/01/2022 C,PARIS,AB88,13790,16/01/2022 C,PARIS,AB88,14090,18/01/2022 ]; Left Join(Table1) LOAD ITEM, LOCATION, LOTN, Max([DELIVERY NUMBER]) as [DELIVERY NUMBER], MAX([DELIVERY DATE]) as [DELIVERY DATE] Resident Table2 Group By ITEM, LOCATION, LOTN Order By ITEM; DROP TABLE Table2; EXIT SCRIPT;

topic Table Join with chronological join in QlikView

Table Join with chronological join

Re: Table Join with chronological join