Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qlikmpate0
Contributor

Interval match question

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?

1 Reply
qlikmpate0
Contributor

Re: Interval match question

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;

Community Browser