topic Re: Interval Match on 2 date ranges in a table in QlikView

Interval Match on 2 date ranges in a table

k_burata — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have this table below:

How do you do interval match to a calendar on the 2 date ranges (PStart/PEnd and EmpStart/EmpEnd) located on 1 table?

So when I select date Mar 2016 I should get Emp 1.

Thanks

Re: Interval Match on 2 date ranges in a table

swuehl — Fri, 19 Aug 2016 22:34:06 GMT

Do you want to filter the records where your select point in time is part of both intervals? Then maybe create the intersection of both intervals and use INTERVALMATCH against this new interval (Start and End) only:

LOAD

Position, PStart, PEnd, Emp, EmpStart, EmpEnd,

RangeMax(EmpStart, PStart) as Start,

RangeMin(EmpEnd, PEnd) as End

FROM ...;