topic Loop to find delivery dates in QlikView https://community.qlik.com/t5/QlikView/Loop-to-find-delivery-dates/m-p/1200591#M880828 <HTML><HEAD></HEAD><BODY><P>Hi Qlik-Community,</P><P></P><P>I am new to QV and at the moment I am building my first app. The content in this community is a great help so far.</P><P></P><P>Maybe you can help me with my next problem as well:</P><P></P><P>I have two tables "Loadings" (at different warehouses) and "Deliveries" (to customers). Unfortunately these tables have no clear connection. </P><P></P><P>"Deliveries" consists only of "CustomerID", "DeliveryDate" and "TourNumber". </P><P>"Loadings" does not contain a "DeliveryDate" but a "LoadingDate". This date is a few days before delivery or at the same day. </P><P>The same "TourNumber" is often used more then one time and not unique. "CustomerID" is included in "Loadings" as well.</P><P></P><P>My idea is to allocate the loading date to my "Deliveries"-Table with a loop-function which finds the last (Max date before delivery) "LoadingDate" allocated to "CustomerID" and maybe "TourNumber". </P><P></P><P>Do you have an idea how I can create this in my script?</P><P></P><P>Thanks in advance for your help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Loop to find delivery dates https://community.qlik.com/t5/QlikView/Loop-to-find-delivery-dates/m-p/1200591#M880828 <HTML><HEAD></HEAD><BODY><P>Hi Qlik-Community,</P><P></P><P>I am new to QV and at the moment I am building my first app. The content in this community is a great help so far.</P><P></P><P>Maybe you can help me with my next problem as well:</P><P></P><P>I have two tables "Loadings" (at different warehouses) and "Deliveries" (to customers). Unfortunately these tables have no clear connection. </P><P></P><P>"Deliveries" consists only of "CustomerID", "DeliveryDate" and "TourNumber". </P><P>"Loadings" does not contain a "DeliveryDate" but a "LoadingDate". This date is a few days before delivery or at the same day. </P><P>The same "TourNumber" is often used more then one time and not unique. "CustomerID" is included in "Loadings" as well.</P><P></P><P>My idea is to allocate the loading date to my "Deliveries"-Table with a loop-function which finds the last (Max date before delivery) "LoadingDate" allocated to "CustomerID" and maybe "TourNumber". </P><P></P><P>Do you have an idea how I can create this in my script?</P><P></P><P>Thanks in advance for your help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Loop-to-find-delivery-dates/m-p/1200591#M880828 2020-11-25T16:16:04Z