Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help with sum of time

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

Tags (5)
1 Solution

Accepted Solutions

Re: Help with sum of time

Hi,

change your expression "Total Time per location" into:

=Interval(sum(TaskExecutionHistoryItem.Duration))

and set number format to "expression default"

QlikCommunity_Thread_1304xx_Pic1.JPG.jpg

hope this helps

regards

Marco

2 Replies

Re: Help with sum of time

Hi,

change your expression "Total Time per location" into:

=Interval(sum(TaskExecutionHistoryItem.Duration))

and set number format to "expression default"

QlikCommunity_Thread_1304xx_Pic1.JPG.jpg

hope this helps

regards

Marco

Re: Re: Help with sum of time

or better use

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

to also show the day-part of those intervals.

QlikCommunity_Thread_130418_Pic2.JPG.jpg

hope this helps

regards

Marco

Community Browser