Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Perform aggregation for IntervalMatch

I want to obtain the average values for some metrics for some given time intervals.

I have achieved it using IntervalMatch but my solution does not scale well when  the EventLog grows.

Is there a way to perform an aggregation (avg, sum,…) within the interval match?

EventLog:

LOAD * Inline [

Time, Measurement

00:00, 0

01:18, 1

02:23, 2

04:15, 3

08:00, 4

11:43, 5

11:44, 5

11:45, 5

11:46, 8

];

OrderLog:

LOAD * INLINE [

Id,Start, End, Order

1,01:00, 03:35, A

2,02:30, 07:58, B

3,03:04, 10:27, C

4,07:23, 11:43, D

];

Inner Join IntervalMatch ( Time )

LOAD Start, End

Resident OrderLog;

/*

I don't want to perform all these joins

*/

Inner Join

LOAD Time, Measurement

Resident EventLog;

Out:

LOAD Id,AVG(Measurement) AS mean

Resident OrderLog

GROUP BY Id;

Drop Table EventLog;

1 Reply
sunny_talwar

What is the expected output for your sample here?