Interval match question

qlikmpate0 — Thu, 19 Jun 2014 09:34:36 GMT

I'm using interval match to create a shift pattern log, but now I have another request where I have three different warehouse all with different shifts how can I separte the warehouses, becuase you can only use one field for intervalmatch.

Any ideas?

Re: Interval match question

qlikmpate0 — Thu, 19 Jun 2014 09:53:00 GMT

my code look like this

LOAD
time#(Start)as [EventStart],
time#(End) as [EventEnd],
ShiftName
Inline
[
EventStart, EventEnd, ShiftName
06:00, 13:59, MO_Shift1
14:00, 21:59, MO_Shift2
22:00, 06:00, MO_Shift3
];
ShipmentsLog:
LOAD
      [Details.Creation Timestamp],
     time([Details.Creation Timestamp]) as EventTime,
     [Details.Last Modified Timestamp]
FROM
[Details.qvd]
(qvd);

Data:
IntervalMatch(EventTime)
Load
[EventStart], [EventEnd]
resident Shifts;

topic Re: Interval match question in QlikView

Interval match question

Re: Interval match question