
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculate avg time
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!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this may be
Avg({<RowA = {">0"}>}RowA)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@sunny_talwar wrote:Try this may be
Avg({<RowA = {">0"}>}RowA)
OMG that's it, it works.
Thank you SO much! 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
