topic Re: can anyone explain Interval match function in qlikview in QlikView

can anyone explain Interval match function in qlikview

honeyasha — Wed, 25 Nov 2020 16:16:04 GMT

can anyone explain Interval match function in qlikview

Thanks.

Chanty4u — Wed, 20 Jun 2018 16:13:19 GMT

Hi,

Have a look

honeyasha — Wed, 20 Jun 2018 17:13:25 GMT

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 — Wed, 20 Jun 2018 17:17:20 GMT

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 — Wed, 20 Jun 2018 23:20:07 GMT

Take a look at this blog post