Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

calculate hours worked per week

hello all stp help me,
I currently work on a project management hours of an agent, the fact I have a picture that I recovered with the expression = intervall (max (time), min (time) )

namedaytime intime outtotal
test1monday07:3017:3008:00
test1Tuesday07:3017:4008:10
test1Wednesday07:3017:3008:00
test1Thursday
07:3017:3008:00
test1Friday07:3017:3008:00
test1Saturday10:3014:3004:00

the problem is that want to sum the results of the previous table depending on the week to another simple table that I wish writing.

I have thought about a loop.

Tags (1)