topic Re: time summation in QlikView

time summation

Thu, 19 Sep 2013 05:11:34 GMT

How to find the sum of time entries in list box

thanks

tresB — Thu, 19 Sep 2013 05:15:17 GMT

Please take a bit more pain to explain better about your requirement. Refer,

Thu, 19 Sep 2013 08:44:03 GMT

my data is as follows :

00:03:10

01:03:10

00:44:40

i want to find sum of above time duration fields

tresB — Thu, 19 Sep 2013 08:49:34 GMT

Is this what you want?

Expression: Time(Sum(YourField), 'hh:mm:ss')

PFA

Thu, 19 Sep 2013 08:56:43 GMT

Hi Sagar,

You can use as below:

Test:

Load * Inline [

Data

00:03:10

01:03:10

00:44:40

];

Then to calculate Sum use : Time(Sum(Data), 'hh:mm:ss')

Hope this helps!