topic calculate hours worked per week in QlikView https://community.qlik.com/t5/QlikView/calculate-hours-worked-per-week/m-p/509000#M687576 <HTML><HEAD></HEAD><BODY><DIV dir="ltr"><SPAN lang="en"><SPAN class="hps">hello all</SPAN> <SPAN class="hps">stp</SPAN> <SPAN class="hps">help</SPAN> <SPAN class="hps">me,</SPAN></SPAN></DIV><DIV dir="ltr"><SPAN lang="en"><SPAN class="hps"> I</SPAN> <SPAN class="hps">currently</SPAN> <SPAN class="hps">work</SPAN> <SPAN class="hps">on a project</SPAN> <SPAN class="hps">management</SPAN> <SPAN class="hps">hours</SPAN> <SPAN class="hps">of an agent,</SPAN> <SPAN class="hps">the fact</SPAN> <SPAN class="hps">I have a</SPAN> <SPAN class="hps">picture that I</SPAN> <SPAN class="hps">recovered</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">the expression =</SPAN> <SPAN class="hps">intervall</SPAN> <SPAN class="hps">(max</SPAN> <SPAN class="hps">(time)</SPAN>, <SPAN class="hps">min</SPAN> <SPAN class="hps">(time)</SPAN> <SPAN class="hps">)</SPAN></SPAN></DIV><DIV dir="ltr"><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></DIV><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">day</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">time in</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">time out</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">total</TH></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;">monday</TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:30</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Tuesday</SPAN></SPAN></TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:40</TD><TD style="padding: 2px;">08:10</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Wednesday</SPAN></SPAN></TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:30</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Thursday <BR /></SPAN></SPAN></TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:30</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Friday</SPAN></SPAN></TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:30</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Saturday</SPAN></SPAN></TD><TD style="padding: 2px;">10:30</TD><TD style="padding: 2px;">14:30</TD><TD style="padding: 2px;">04:00</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P><SPAN lang="en"><SPAN class="hps">the</SPAN> <SPAN class="hps">problem is that</SPAN> <SPAN class="hps">want</SPAN> <SPAN class="hps">to sum the</SPAN> <SPAN class="hps">results</SPAN> <SPAN class="hps">of the</SPAN> <SPAN class="hps">previous</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">depending on the</SPAN> <SPAN class="hps">week</SPAN> <SPAN class="hps">to another</SPAN> <SPAN class="hps">simple table</SPAN> <SPAN class="hps">that I</SPAN> <SPAN class="hps">wish</SPAN> <SPAN class="hps">writing.</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">I have</SPAN> <SPAN class="hps">thought about</SPAN> <SPAN class="hps">a loop. <BR /></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 29 Nov 2013 10:10:49 GMT 2013-11-29T10:10:49Z calculate hours worked per week https://community.qlik.com/t5/QlikView/calculate-hours-worked-per-week/m-p/509000#M687576 <HTML><HEAD></HEAD><BODY><DIV dir="ltr"><SPAN lang="en"><SPAN class="hps">hello all</SPAN> <SPAN class="hps">stp</SPAN> <SPAN class="hps">help</SPAN> <SPAN class="hps">me,</SPAN></SPAN></DIV><DIV dir="ltr"><SPAN lang="en"><SPAN class="hps"> I</SPAN> <SPAN class="hps">currently</SPAN> <SPAN class="hps">work</SPAN> <SPAN class="hps">on a project</SPAN> <SPAN class="hps">management</SPAN> <SPAN class="hps">hours</SPAN> <SPAN class="hps">of an agent,</SPAN> <SPAN class="hps">the fact</SPAN> <SPAN class="hps">I have a</SPAN> <SPAN class="hps">picture that I</SPAN> <SPAN class="hps">recovered</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">the expression =</SPAN> <SPAN class="hps">intervall</SPAN> <SPAN class="hps">(max</SPAN> <SPAN class="hps">(time)</SPAN>, <SPAN class="hps">min</SPAN> <SPAN class="hps">(time)</SPAN> <SPAN class="hps">)</SPAN></SPAN></DIV><DIV dir="ltr"><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></DIV><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">day</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">time in</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">time out</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">total</TH></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;">monday</TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:30</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Tuesday</SPAN></SPAN></TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:40</TD><TD style="padding: 2px;">08:10</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Wednesday</SPAN></SPAN></TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:30</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Thursday <BR /></SPAN></SPAN></TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:30</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Friday</SPAN></SPAN></TD><TD style="padding: 2px;">07:30</TD><TD style="padding: 2px;">17:30</TD><TD style="padding: 2px;">08:00</TD></TR><TR><TD style="padding: 2px;">test1</TD><TD style="padding: 2px;"><SPAN lang="en"><SPAN class="hps">Saturday</SPAN></SPAN></TD><TD style="padding: 2px;">10:30</TD><TD style="padding: 2px;">14:30</TD><TD style="padding: 2px;">04:00</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P><SPAN lang="en"><SPAN class="hps">the</SPAN> <SPAN class="hps">problem is that</SPAN> <SPAN class="hps">want</SPAN> <SPAN class="hps">to sum the</SPAN> <SPAN class="hps">results</SPAN> <SPAN class="hps">of the</SPAN> <SPAN class="hps">previous</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">depending on the</SPAN> <SPAN class="hps">week</SPAN> <SPAN class="hps">to another</SPAN> <SPAN class="hps">simple table</SPAN> <SPAN class="hps">that I</SPAN> <SPAN class="hps">wish</SPAN> <SPAN class="hps">writing.</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">I have</SPAN> <SPAN class="hps">thought about</SPAN> <SPAN class="hps">a loop. <BR /></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 29 Nov 2013 10:10:49 GMT https://community.qlik.com/t5/QlikView/calculate-hours-worked-per-week/m-p/509000#M687576 2013-11-29T10:10:49Z