IntervalMatch function issues with date range and additional field

Qbo — Fri, 15 Nov 2024 23:11:32 GMT

Having issues with IntervalMatch() function. Just want to tie two tables together by a common ID and date range. Have tried it various different ways and just can't seem to get the solution. Any help would be greatly appreciated. Here is where I've gotten to:

A: LOAD Distinct booking_id, id, TDate, //floored date field level FROM [..\QVDs\A.qvd] (qvd); B: LOAD Distinct id, cBooking, cdate as Start, //floored date field NEXT_cdate as End //floored date field FROM [..\QVDs\B.qvd] (qvd); INNER JOIN IntervalMatch(TDate,id) LOAD Distinct Start, End, id Resident B;

Have tried to anonymize it as much as possible so hopefully it is still clear for you guys. Basically I want to join the two tables on the id and Start/End dates so I can get the average level for that id within that range if that makes sense. Be gentle with me if I have posted in the wrong section or if you feel this has been beaten to death as I have looked over numerous posts and cannot get this to work for me.

This last solution I have arrived at is pulled directly from Qlik and is basically copied verbatim: From Here

Thanks in advance

Re: IntervalMatch function issues with date range and additional field

Qbo — Fri, 05 Feb 2021 07:54:32 GMT

Have resolved the issue, dates were back to front to on the End range sort and match wasn't working.

topic Re: IntervalMatch function issues with date range and additional field in QlikView

IntervalMatch function issues with date range and additional field

Re: IntervalMatch function issues with date range and additional field