topic Time Intervals in QlikView

Time Intervals

Fri, 21 Mar 2014 13:46:32 GMT

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

Re: Time Intervals

Nicole-Smith — Fri, 21 Mar 2014 13:49:18 GMT

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...

Re: Time Intervals

Fri, 21 Mar 2014 13:51:31 GMT

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