Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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