topic Re: Doubt in Interval Match in QlikView

Doubt in Interval Match

Wed, 13 Apr 2011 13:03:58 GMT

I have some queries regarding the Interval Match function. I want to know what will be the bahaviour of interval match function if the data is as shown below. I am using the code which is given below and all those rows which is having data as shown below are not getting displayed. So would like to know about the behaviour of this interval match function.

Example data:

StartDate: 31/03/2011 15:07:00

EndDate: 31/03/2011 15:07:00


 IntervalMatch(date)
LOAD ImplStart, ImplEnd RESIDENT Data;

Doubt in Interval Match

Wed, 13 Apr 2011 13:18:45 GMT

Hi,

If I have such a problem I would use also the date funtction.

In this case you know for sure that it wil be the right date.

So something like

IntervalMatch(DATE(date))

I hope this helps.

If not please upload an example.

Kind regards,

Martijn

Re: Doubt in Interval Match

Miguel_Angel_Baeyens — Tue, 08 Sep 2020 10:05:10 GMT

Hello,

If you mean what happens when the start and end date for the range are the same, if there is one record with the same date, will match in the range. Check the following script:

Facts: LOAD * INLINE [ Code, Date AAA, 01/01/2011 1:20:00 BBB, 01/01/2011 1:21:00 CCC, 01/01/2011 1:22:00 ]; Intervals: LOAD * INLINE [ Start, End, Name 01/01/2011 1:20:00, 01/01/2011 1:20:00, A 01/01/2011 1:21:00, 01/01/2011 1:21:00, B ]; FactsWithIntervals: INTERVALMATCH (Date) LOAD Start, End RESIDENT Intervals ; JOIN LOAD * RESIDENT Intervals; DROP TABLE Intervals; OnlyOneRecordPerInterval: RIGHT KEEP LOAD Code, Date RESIDENT Facts; JOIN LOAD * RESIDENT FactsWithIntervals; DROP TABLE Facts; DROP TABLE FactsWithIntervals;

Hope that helps.