topic IntervalMatch in QlikView

IntervalMatch

jagannalla — Thu, 20 Oct 2011 13:22:33 GMT

Hi All,

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.

Re: IntervalMatch

its_anandrjs — Thu, 20 Oct 2011 13:27:19 GMT

Hi,

I explain with an example there is two tables below

OrderLog:

load * inline

[

START,END ,ORDER

01:00,03:00 ,A

03:01,05:00 ,B

05:01,07:00 ,C

07:01,09:00 ,D

09:01,11:00 ,E

];

EventLog:

load * inline

[

Time,Event,Comment

00:00,0,Start of shift 1

02:00,1,Line Stop

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

];

Data:

Intervalmatch(Time) load

START,END

Resident OrderLog;

The two tables OrderLog and EventLog loaded noramally after that we need to create interval table like

Data:

Intervalmatch(Time) load

START,END

Resident OrderLog;

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.

Rgds

Anand

IntervalMatch

jagannalla — Thu, 20 Oct 2011 13:56:11 GMT

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.

IntervalMatch

its_anandrjs — Thu, 20 Oct 2011 14:01:24 GMT

Hi,

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

Rgds

Anand

Re: IntervalMatch

jagannalla — Thu, 20 Oct 2011 14:10:08 GMT

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.

Temp:

IntervalMatch(carrdatetime)

LOAD Shift.ShiftStart,

Shift.ShiftEnd

Resident Shift;

Inner Join (Temp)

LOAD Shift.ShiftKey, Shift.ShiftStart, Shift.ShiftEnd

Resident Shift;

Inner Join (Inspection)

LOAD Shift.ShiftKey, carrdatetime

Resident Temp;

DROP Table Temp;