can anyone explain Interval match function in qlikview

[honeyasha]

can anyone explain Interval match function in qlikview

Thanks.

[Chanty4u]

Hi,

Have a look

IntervalMatch function

[honeyasha]

Thanks Chanty this link really helps for me .

Can you brief me in which scenarios we will use Interval match as i am new to qlikview.

[Chanty4u]

Check this simple example related to the Interval Match from Qlik Help

OrderLog:

LOAD * INLINE [

    Start, End, Order

    01:00, 03:35, A

    02:30, 07:58, B

    03:04, 10:27, C

    07:23, 11:43, D

];

EventLog:

LOAD * INLINE [

    Time, Event, Comment

    00:00, 0, Start of shift 1

    01:18, 1, Line stop

    02:23, 2, Line restart 50%

    04:15, 3, Line speed 100%

    08:00, 4, Start of shift 2

    11:43, 5, End of production

];

IntervalMatch (Time) LOAD Start, End Resident OrderLog;

[albertovarela]

Take a look at this blog post

Using IntervalMatch()