1 Reply Latest reply: Aug 11, 2014 3:41 AM by Tresesco B RSS

    IntervalMatch not working with qualified tables

      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
          Tresesco B

          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;