Most recent record prior to ship date

nburton78 — Sat, 16 Nov 2024 20:33:57 GMT

I have 2 tables, sales information and purchasing status. The 2 tables connect on the field "lot". The issue is, that the purchasing status table has multiple records for each lot. So I'd like to specify that I want to see the most recent inbound status field where the receipt date is before the ship date. I tried to do this in the straight table with this expression "Max(if(receipt date <=Ship date,inbound status))" but it doesn't retrieve anything. What am I doing wrong? Here's a sample of my load script:

table sales:

load

sales order number

sales line number

sales order type

ship date

lot;

{SQL}

table Purchasing status:

load

lot

receipt date

inbound status;

{SQL}

Re: Most recent record prior to ship date

sasiparupudi1 — Sat, 29 Jun 2019 18:40:02 GMT

Try MaxString

MaxString(if(receipt date <=Ship date,inbound status))

Re: Most recent record prior to ship date

nburton78 — Tue, 02 Jul 2019 16:36:13 GMT

Thank you that worked perfectly! thank you thank you thank you

topic Re: Most recent record prior to ship date in QlikView

Most recent record prior to ship date

Re: Most recent record prior to ship date

Re: Most recent record prior to ship date