Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator II

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
Creator II
Creator II
Author

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;