Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

time summation

How to find the sum of time entries in list box

thanks

SK

4 Replies
tresesco
MVP
MVP

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

How to Get Answer to Your Question

Not applicable
Author

my data is as follows : 

00:03:10

01:03:10

00:44:40

i want to find sum of above time duration fields

tresesco
MVP
MVP

Is this what you want?

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

PFA

Not applicable
Author

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!