Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
EliGohar
Partner - Creator III
Partner - Creator III

Average duration calc - which expression is more efficient in terms of performance?

Hi,

I wrote two versions of Avg duration calculation and I want to understand which one is better in terms of performance:

Version 1:

interval(Avg(aggr(sum({<[Class Category ID]={0}>} Duration),ObjectID)))

Version 2:

interval(sum({<[Class Category ID]={0}>} Duration) / count({<[Class Category ID]={0}>} ObjectID))

ObjectID is unique value (No duplicate values)

Thanks,

Eli.

0 Replies