topic Re: Re: Help with sum of time in QlikView

Help with sum of time

Fri, 22 Aug 2014 14:18:44 GMT

Hello all,

yet again I turn to this lovely community for answers and help.

I have a problem with summation of time, as you can see in attached file.

The total for Total Time per location is not valid, as you can see it should be in days not in hours.

Is that a problem? Is there a limit in how much data can be stored?

Can you help me to get it right, and to get right percentages?

Thanks in advance

MarcoWedel — Fri, 22 Aug 2014 14:30:31 GMT

Hi,

change your expression "Total Time per location" into:

=Interval(sum(TaskExecutionHistoryItem.Duration))

and set number format to "expression default"

hope this helps

regards

Marco

MarcoWedel — Fri, 22 Aug 2014 14:39:29 GMT

or better use

=Interval(sum(TaskExecutionHistoryItem.Duration), 'DD hh:mm:ss')

to also show the day-part of those intervals.

hope this helps

regards

Marco