how to sum up duration times

[omyahamburg]

Hello all

I have a small table where for each person/week/date a start and end time is created.

In the script I can calculate the duration per day. That looks fine so far.

I now want to sum these duration times in a straight table for each person per week (as dimension),

but this does not work at all. It shows me for each '01:14:33' a sum.

Could somebody bring me to the right direction how to calculate this ?

I do attach my sample qvw.

Thanks

Joerg

[#2]

add new Code to your Script

X:

LOAD Name ,Sum(Duration) as Total

Resident table

Group by Name ;

DROP Table tmp;

hope this helps

[#3 · Accepted solution]

hi jorg

please  Find Attachment

[omyahamburg]

Hi qlik learn

Thanks a lot, works with perfect !

Joerg

[#5]

Hi Jörg

I think it works correctly. It just happened that duration for both Names is the same.

btw, displaying as Interval is probably better in this case (Chart Properties => Number => Interval)

Lukasz

[omyahamburg]

Thanks Lukasz, you are right, with interval the time is correctly shown.

Joerg