IntervalMatch not working with qualified tables

Mon, 11 Aug 2014 07:25:53 GMT

How do I make IntervalMatch work with qualified tables?

I like to qualify my tables because of large queries and thereby have more control over qlikviews joining. But this gives me a problem using IntervalMatch. Can anybody explain how I can use intervalmatch with qualified tables. See attached example.

Re: IntervalMatch not working with qualified tables

tresB — Mon, 11 Aug 2014 07:41:48 GMT

One Unqualify * would be required before last interval match, like:

OrderLog:
LOAD * INLINE [
Start, End, Order
01:00, 03:35, A
02:30, 07:58, B
03:04, 10:27, C
07:23, 11:43, D
];

EventLog:
LOAD * INLINE [
Time, Event, Comment
00:00, 0, Start of shift 1
01:18, 1, Line stop
02:23, 2, Line restart 50%
04:15, 3, Line speed 100%
08:00, 4, Start of shift 2
11:43, 5, End of production
];

IntervalMatch (Time) LOAD Start, End Resident OrderLog;

Qualify "*";

OrderLogI:
LOAD * INLINE [
Start, End, Order
01:00, 03:35, A
02:30, 07:58, B
03:04, 10:27, C
07:23, 11:43, D
];

EventLogI:
LOAD * INLINE [
Time, Event, Comment
00:00, 0, Start of shift 1
01:18, 1, Line stop
02:23, 2, Line restart 50%
04:15, 3, Line speed 100%
08:00, 4, Start of shift 2
11:43, 5, End of production
];
UNQUALIFY *;
IntervalMatch (EventLogI.Time) LOAD OrderLogI.Start, OrderLogI.End Resident OrderLogI;

topic IntervalMatch not working with qualified tables in QlikView

IntervalMatch not working with qualified tables

Re: IntervalMatch not working with qualified tables