Time Intervals

[#1]

Hello,

I am new to QlikView developing and I am running into some some issues attempting to create time intervals for different shifts.

The scenario is that I am trying to create a ListBox that displays different shifts based on a Dt_tm field. I can load the inline tables but I cannot get the data to relate to the actual dates and times. Ideally I would like to have 24 hrs broken into three shifts.

Below is what I have thus far and any help/advice is greatly appreciated!

Shifts:

load * inline

[

START,END   ,Shifts

01:00,08:00 ,A

08:01,04:00 ,B

04:01,12:00 ,C

];

Data:

Intervalmatch(CHECKIN_DT_TM) load

START,END

Resident Shifts;

Thanks in advance!

Jordan

[Nicole-Smith]

Jordan Ketch wrote:

Data:

Intervalmatch(CHECKIN_DT_TM) load

START,END

Resident Shifts;

Where are you loading in the CHECKIN_DT_TM field?  It needs to be before you use the interval match function...

[#3]

It is a field that I am pulling from our connection. I think that is where my knowledge gap is - not sure where/how to relate it.

Thanks for the quick reply!

Jordan