topic Re: Intervalmatch, where interval = 0 in QlikView

Intervalmatch, where interval = 0

hansdevr — Tue, 21 Jun 2016 11:45:25 GMT

Maybe a silly question, but I am sort of suspecting this issue to be the source of my problem..

Let's suppose that I have a reference date: 2016/06/19..

When start date and end date in my record are respectively 2016/06/15 and 2016/06/20, then IntervalMatch() sees this range as fitting with the reference date.

But what happens when start and end date are equal to the reference date?

I get the feeling that there is no IntervalMatch() found for this situation...

Thoughts anyone?

Re: Intervalmatch, where interval = 0

hansdevr — Tue, 21 Jun 2016 12:21:54 GMT

Just to clarify: Peildatum means reference date; Datum start = start date and Datum einde = end date. As you can see, reference date 20-6-2016 is grayed out..

Re: Intervalmatch, where interval = 0

Tue, 21 Jun 2016 12:29:26 GMT

My understanding IntervalMatch include the boundary values (start and end dates) to match the reference dates.

I just wondering why the table box (first image) showing the association values between start, end and reference dates and reference date LB is greyed out.

Re: Intervalmatch, where interval = 0

hansdevr — Tue, 21 Jun 2016 12:32:09 GMT

Yes, I was under the impression that IntervalMatch() includes both start and end values as well... So - with you - I am wondering why the reference date is greyed out.. Is it because start end end values are identical?!?

Re: Intervalmatch, where interval = 0

marcus_sommer — Tue, 21 Jun 2016 12:35:48 GMT

Are you sure that your intervalmatch worked like descriped here: IntervalMatch and that you haven't excluded these Peildatum with other selections?

As an alternatively to intervalmatch especially if there are more key-fields is the use of a while-loop with iterno() which gives you more control and more flexibility by creating the intervals.

- Marcus

Re: Intervalmatch, where interval = 0

hansdevr — Tue, 21 Jun 2016 12:44:29 GMT

I did create a master calender table, using iterno().. And of course I already read that blog entry by Henric...

I added my script in .txt format...

Re: Intervalmatch, where interval = 0

swuehl — Tue, 21 Jun 2016 13:46:25 GMT

Double check that your date fields are really showing dates (integers) and not timestamps (values with decimals) as numeric representation, e.g. don't use

date([Res. aanmaakdatum]) as [Aanmaakdatum]

in your first LOAD if you want to get a real date, but be safe using

date(Floor([Res. aanmaakdatum])) as [Aanmaakdatum]

Also double check the other date field transformations.

Re: Intervalmatch, where interval = 0

hansdevr — Tue, 21 Jun 2016 13:51:08 GMT

Thanks for your reply! date() is specified in my load script as having the standard format DD-MM-YYYY, so it should be OK. That date is BTW created to get a possibility to aggregate all created [Res. aanmaakdatum] (resolution up to 1/10000 second) to one single day per claim.

Re: Intervalmatch, where interval = 0

swuehl — Tue, 21 Jun 2016 13:56:10 GMT

Date() will only reformat your value, keeping the underlying numeric representation.

Intervalmatch() will match based on the numeric values, so if your start and end dates are in fact timestamps, they won't match with your pure calendar date values from the master calendar.

AFAIR, we had a similar topic in one of your other threads.

Why don’t my dates work?

Get the Dates Right

Re: Intervalmatch, where interval = 0

hansdevr — Tue, 21 Jun 2016 13:57:58 GMT

Alright, you convinced me... Gonna try that and get back to you...

Re: Intervalmatch, where interval = 0

hansdevr — Wed, 22 Jun 2016 06:03:25 GMT

You were right. After checking all of the date formats, it worked.

Thanks again!!

Hans