Discussion Board for collaboration related to QlikView App Development.
Can any one explain me how the intervalmatch function works with beautiful example...I gone through reference manual pdf but there is no example. I understood little bit only.
I explain with an example there is two tables below
load * inline
00:00,0,Start of shift 1
04:00,2,Line Restart 50%
06:00,3,Line Speed 100%
08:00,4,Start of shift 2
11:00,5,End of Production
The two tables OrderLog and EventLog loaded noramally after that we need to create interval table like
and then we get interval table with six fields a time column shows in which Time interval he comes in START and END time.
See the attached sample file.
View solution in original post
Thanks a lot for breify explination..but in which scenario we will go with interval match. I mean what output should we get while using interval match.
If we want to set interval matchs for perticular type of groups like age suppose 10 age and we have this values so if i want to check in which intervals it is comes like is i say 5 to 15 whih is comes in this interval and i create a fields like
5 to 15
16 to 25
26 to 35
some thing like that
Thanks a lot..
can you explain how the following code works..
- Inspection table contains the field carrdatetime
- Shift table contains the fields Shift.ShiftKey, Shift.ShiftStart, Shift.ShiftEnd.
Inner Join (Temp)
LOAD Shift.ShiftKey, Shift.ShiftStart, Shift.ShiftEnd
Inner Join (Inspection)
LOAD Shift.ShiftKey, carrdatetime
DROP Table Temp;