Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Using intervalmatch for dates and times

Hi, I'm hoping someone can help please. This is my first post so I hope I have given enough information. I'm using QV 11 SR1 64bit.

I have a table that defines some shift patterns. For each day there are three eight-hour shifts. The shifts are named blue, green and orange. Over a number of months the hours to which these shift colours relate change. E.g. in January orange could be 8 a.m. to 4 p.m.. but then in February orange could be midnight to 8 a.m. This is because the operators in these shifts stay with a particular shift colour but this then means they don't constantly work the same shift month after month.

DateFromDateTo
TimeFrom
TimeTo
Shift
01/01/1231/01/1200:0108:00Blue
01/01/1231/01/1208:0116:00Orange
01/01/1231/01/1216:0100:00Green





01/02/1229/02/1200:0108:00Orange
01/02/1229/02/1208:0116:00Green
01/02/1229/02/1216:0100:00Blue
etc



The operators log transactions (e.g. stock movements in a warehouse) and the date and time of the transaction are logged in a table. I want to be able to relate the date and time of the transaction to a shift colour. I was hoping that intervalmatch might be able to help but I'm not sure how to do this when I have a date range and a time range to be able to refer to a particular shift.

Thanks.

Tags (1)
Community Browser