Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
change your expression "Total Time per location" into:
and set number format to "expression default"
hope this helps
or better use
=Interval(sum(TaskExecutionHistoryItem.Duration), 'DD hh:mm:ss')
to also show the day-part of those intervals.