Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jagannalla
Partner
Partner

IntervalMatch

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.

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

4 Replies
its_anandrjs

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

View solution in original post

jagannalla
Partner
Partner
Author

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.

its_anandrjs

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

jagannalla
Partner
Partner
Author

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;