topic SUM Duration in QlikView

SUM Duration

Mon, 10 May 2010 13:39:56 GMT

Hi,

pls can any body tell me how to get the sum of duration

for eg:

00:01:02

00:00:03

and the sum will be 00:01:05

Duration is a field in the database.

Thanks & Regards,

Arun

SUM Duration

Mon, 10 May 2010 13:48:58 GMT

sum(Duration)

SUM Duration

Mon, 10 May 2010 14:06:08 GMT

Hi Arun,

The post given above will solve your issue. But when you get it in a list bos, it shows you some decimal value. In order to override this, go to the list box properties and override the dimension with time format. Or you can do it in the script part by specifing the format fot the time. That is like given belo:

Sum(Time)

and then Time(timefeild,'HH:MM:SS')

hope this solves your issue.

Thanks Joseph.....

SUM Duration

johnw — Mon, 10 May 2010 20:59:32 GMT

If Duration is a formatted interval of time, sum(Duration) appears to preserve the formatting. If you have to format it manually for some reason, use interval instead of time. Time is the time on a clock, like 8:00 AM, not a duration of time. Interval is used for a duration of time, like 8 hours.

SUM Duration

Mon, 10 May 2010 21:18:14 GMT

You Can Try this.


Interval (Sum([Duration]))

Regards.
Tonial.