topic Re: IntervalMatch with Dates Inside in QlikView

IntervalMatch with Dates Inside

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

Hey guys!

I have following code:

[Test]:

LOAD

Date(25569+[start_epoch]/24/60/60) as StartEpoch,

Date(25569+[end_epoch]/24/60/60) as EndEpoch

FROM ...;

[Intervals]:

IntervalMatch (Date) //Date is stored in MasterCalendar Table

LOAD

StartEpoch,

EndEpoch

Resident [Test];

After loading the script I have the following situation:

Why do I have wrong matching of StartDate?

I know how I can fix it for further work. I'm asking about the correct explanation of this issue.

Thank you

Elena

Re: IntervalMatch with Dates Inside

Gysbert_Wassenaar — Wed, 10 Aug 2016 12:25:00 GMT

Looks ok to me. What do you think is wrong?

Re: IntervalMatch with Dates Inside

Anonymous — Wed, 10 Aug 2016 12:35:24 GMT

Hey, Gysbert!

I thought that if i have 18/1/2016 as StartDate, then the interval should be 18/1/2016, 19/1/2016 and 20/1/2016. The same as we write it: 18/1/2016-20/1/2016 means 3 days period, but not 2. I expected to have same result.

Elena

Re: IntervalMatch with Dates Inside

Gysbert_Wassenaar — Wed, 10 Aug 2016 14:17:17 GMT

Then you should make sure you're working with dates and not timestamps. 18/01/2016 12:34:56 is larger than 18/01/2016.

Re: IntervalMatch with Dates Inside

Anonymous — Wed, 10 Aug 2016 14:22:16 GMT

That makes sense. Thank you a lot, Gysbert!