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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
EliGohar
Partner - Specialist
Partner - Specialist

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