Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
viveksairam89
Contributor

How to take average for HH:mm:ss

Hi,

I am trying for a expression someone can help me for taking Average for hh:mm:ss

I have converted Seconds to hh:mm:ss

Used expression Avg(waittime/3600)

In excel when we calculate its perfect but in qliksense getting a different average

1 Solution

Accepted Solutions

Re: How to take average for HH:mm:ss

Seems to be working for me

Capture.PNG

3 Replies

Re: How to take average for HH:mm:ss

Would you be able to share the sample data you tried to work with in Excel?

viveksairam89
Contributor

Re: How to take average for HH:mm:ss

i have converted seconds to hh:mm:ss using 3600

and applied Avg(waittime/3600)

0:00:00
3:35:12
0:36:00

Average in Excel=1:23:44 showing correct

But iam not getting this value in qliksense

Re: How to take average for HH:mm:ss

Seems to be working for me

Capture.PNG

Community Browser