Calculate avg time

Anonymous — Sat, 16 Nov 2024 21:49:23 GMT

Good evening,

I'm quite new to Qlik Sense and Google seems to be giving me lots of different search results so I'm gonna try to ask my question here;

I'm creating an app to display the daily phone usage in our company.
We get a list from average ringing times (contains data in HH:MM:SS format).
When I want to create an average of that list using the AVG(RowA) function, I get a wrong result.

This is the data from one of the rows (RowA):

00:00:58
00:00:00
00:00:00
00:00:00
00:00:00
00:00:00
00:00:00
00:00:00
00:00:00
00:02:12

Qlik Sense displays 00:00:19 as an average time while in fact the avg time is 00:01:35 .

Can anyone help me to find the correct expression I need to display the correct average time?

Thank you very much!

Re: Calculate avg time

sunny_talwar — Tue, 27 Nov 2018 18:08:53 GMT

Try this may be

Avg({<RowA = {">0"}>}RowA)

Re: Calculate avg time

Anonymous — Tue, 27 Nov 2018 19:10:54 GMT

@sunny_talwar wrote:
Try this may be
Avg({<RowA = {">0"}>}RowA)

OMG that's it, it works.

Thank you SO much! 🙂

Re: Calculate avg time

sunny_talwar — Tue, 27 Nov 2018 19:45:26 GMT

Awesome 🙂

topic Re: Calculate avg time in App Development

Calculate avg time

Re: Calculate avg time

Re: Calculate avg time

Re: Calculate avg time