topic Calculating employees' shift time work in App Development https://community.qlik.com/t5/App-Development/Calculating-employees-shift-time-work/m-p/2144985#M93168 <P>Hi All,</P> <P>the employees have 3 shifts. I would like to know if the malfunctions of the employees here were caused by my shift time or if they did it afterwards.</P> <P>Shıft hours mean:</P> <P>1= 08:00-16:00 2=08:00-24:00 3=00:00-24:00</P> <P>Table A:</P> <TABLE width="180"> <TBODY> <TR> <TD width="108">work_date</TD> <TD width="72">Shıft_Hours</TD> </TR> <TR> <TD>21.03.2023</TD> <TD>1</TD> </TR> <TR> <TD>22.03.2023</TD> <TD>2</TD> </TR> <TR> <TD>23.03.2023</TD> <TD>3</TD> </TR> <TR> <TD>24.03.2023</TD> <TD>1</TD> </TR> <TR> <TD>25.03.2023</TD> <TD>1</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Table B:</P> <TABLE width="625px"> <TBODY> <TR> <TD width="123.453px">Peronel_number</TD> <TD width="168.273px">work_date</TD> <TD width="168.625px">Fault_Time_start</TD> <TD width="163.648px">Fault_Time_End</TD> </TR> <TR> <TD width="123.453px">312879</TD> <TD width="168.273px">21.03.2023</TD> <TD width="168.625px">21.03.2023 17:05</TD> <TD width="163.648px">21.03.2023 19:35</TD> </TR> <TR> <TD width="123.453px">987476</TD> <TD width="168.273px">22.03.2023</TD> <TD width="168.625px">22.03.2023 21:15</TD> <TD width="163.648px">22.03.2023 219</TD> </TR> <TR> <TD width="123.453px">73639</TD> <TD width="168.273px">23.03.2023</TD> <TD width="168.625px">23.03.2023 08:11</TD> <TD width="163.648px">23.03.2023 11:15</TD> </TR> <TR> <TD width="123.453px">83693</TD> <TD width="168.273px">24.03.2023</TD> <TD width="168.625px">24.03.2023 14:00</TD> <TD width="163.648px">24.03.2023 15:00</TD> </TR> <TR> <TD width="123.453px">44973</TD> <TD width="168.273px">25.03.2023</TD> <TD width="168.625px">25.03.2023 14:00</TD> <TD width="163.648px">25.03.2023 17:00</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to result</P> <P>Result_Table:</P> <TABLE width="676"> <TBODY> <TR> <TD width="123.453px" height="25px">Peronel_number</TD> <TD width="116.016px" height="25px">work_date</TD> <TD width="149.344px" height="25px">Fault_Time_start</TD> <TD width="153.992px" height="25px">Fault_Time_End</TD> <TD width="132.195px" height="25px">Fault_Time</TD> </TR> <TR> <TD width="123.453px" height="25px">312879</TD> <TD width="116.016px" height="25px">21.03.2023</TD> <TD width="149.344px" height="25px">21.03.2023 17:05</TD> <TD width="153.992px" height="25px">21.03.2023 19:35</TD> <TD width="132.195px" height="25px">00:00</TD> </TR> <TR> <TD width="123.453px" height="25px">987476</TD> <TD width="116.016px" height="25px">22.03.2023</TD> <TD width="149.344px" height="25px">22.03.2023 21:15</TD> <TD width="153.992px" height="25px">22.03.2023 22:19</TD> <TD width="132.195px" height="25px">01:04</TD> </TR> <TR> <TD width="123.453px" height="25px">73639</TD> <TD width="116.016px" height="25px">23.03.2023</TD> <TD width="149.344px" height="25px">23.03.2023 08:11</TD> <TD width="153.992px" height="25px">23.03.2023 11:15</TD> <TD width="132.195px" height="25px">03:04</TD> </TR> <TR> <TD width="123.453px" height="25px">83693</TD> <TD width="116.016px" height="25px">24.03.2023</TD> <TD width="149.344px" height="25px">24.03.2023 14:00</TD> <TD width="153.992px" height="25px">24.03.2023 15:00</TD> <TD width="132.195px" height="25px">01:00</TD> </TR> <TR> <TD width="123.453px" height="25px">44973</TD> <TD width="116.016px" height="25px">25.03.2023</TD> <TD width="149.344px" height="25px">25.03.2023 14:00</TD> <TD width="153.992px" height="25px">25.03.2023 17:00</TD> <TD width="132.195px" height="25px">02:00</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank you for help.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 06 Dec 2023 19:31:24 GMT krmvacar 2023-12-06T19:31:24Z Calculating employees' shift time work https://community.qlik.com/t5/App-Development/Calculating-employees-shift-time-work/m-p/2144985#M93168 <P>Hi All,</P> <P>the employees have 3 shifts. I would like to know if the malfunctions of the employees here were caused by my shift time or if they did it afterwards.</P> <P>Shıft hours mean:</P> <P>1= 08:00-16:00 2=08:00-24:00 3=00:00-24:00</P> <P>Table A:</P> <TABLE width="180"> <TBODY> <TR> <TD width="108">work_date</TD> <TD width="72">Shıft_Hours</TD> </TR> <TR> <TD>21.03.2023</TD> <TD>1</TD> </TR> <TR> <TD>22.03.2023</TD> <TD>2</TD> </TR> <TR> <TD>23.03.2023</TD> <TD>3</TD> </TR> <TR> <TD>24.03.2023</TD> <TD>1</TD> </TR> <TR> <TD>25.03.2023</TD> <TD>1</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Table B:</P> <TABLE width="625px"> <TBODY> <TR> <TD width="123.453px">Peronel_number</TD> <TD width="168.273px">work_date</TD> <TD width="168.625px">Fault_Time_start</TD> <TD width="163.648px">Fault_Time_End</TD> </TR> <TR> <TD width="123.453px">312879</TD> <TD width="168.273px">21.03.2023</TD> <TD width="168.625px">21.03.2023 17:05</TD> <TD width="163.648px">21.03.2023 19:35</TD> </TR> <TR> <TD width="123.453px">987476</TD> <TD width="168.273px">22.03.2023</TD> <TD width="168.625px">22.03.2023 21:15</TD> <TD width="163.648px">22.03.2023 219</TD> </TR> <TR> <TD width="123.453px">73639</TD> <TD width="168.273px">23.03.2023</TD> <TD width="168.625px">23.03.2023 08:11</TD> <TD width="163.648px">23.03.2023 11:15</TD> </TR> <TR> <TD width="123.453px">83693</TD> <TD width="168.273px">24.03.2023</TD> <TD width="168.625px">24.03.2023 14:00</TD> <TD width="163.648px">24.03.2023 15:00</TD> </TR> <TR> <TD width="123.453px">44973</TD> <TD width="168.273px">25.03.2023</TD> <TD width="168.625px">25.03.2023 14:00</TD> <TD width="163.648px">25.03.2023 17:00</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to result</P> <P>Result_Table:</P> <TABLE width="676"> <TBODY> <TR> <TD width="123.453px" height="25px">Peronel_number</TD> <TD width="116.016px" height="25px">work_date</TD> <TD width="149.344px" height="25px">Fault_Time_start</TD> <TD width="153.992px" height="25px">Fault_Time_End</TD> <TD width="132.195px" height="25px">Fault_Time</TD> </TR> <TR> <TD width="123.453px" height="25px">312879</TD> <TD width="116.016px" height="25px">21.03.2023</TD> <TD width="149.344px" height="25px">21.03.2023 17:05</TD> <TD width="153.992px" height="25px">21.03.2023 19:35</TD> <TD width="132.195px" height="25px">00:00</TD> </TR> <TR> <TD width="123.453px" height="25px">987476</TD> <TD width="116.016px" height="25px">22.03.2023</TD> <TD width="149.344px" height="25px">22.03.2023 21:15</TD> <TD width="153.992px" height="25px">22.03.2023 22:19</TD> <TD width="132.195px" height="25px">01:04</TD> </TR> <TR> <TD width="123.453px" height="25px">73639</TD> <TD width="116.016px" height="25px">23.03.2023</TD> <TD width="149.344px" height="25px">23.03.2023 08:11</TD> <TD width="153.992px" height="25px">23.03.2023 11:15</TD> <TD width="132.195px" height="25px">03:04</TD> </TR> <TR> <TD width="123.453px" height="25px">83693</TD> <TD width="116.016px" height="25px">24.03.2023</TD> <TD width="149.344px" height="25px">24.03.2023 14:00</TD> <TD width="153.992px" height="25px">24.03.2023 15:00</TD> <TD width="132.195px" height="25px">01:00</TD> </TR> <TR> <TD width="123.453px" height="25px">44973</TD> <TD width="116.016px" height="25px">25.03.2023</TD> <TD width="149.344px" height="25px">25.03.2023 14:00</TD> <TD width="153.992px" height="25px">25.03.2023 17:00</TD> <TD width="132.195px" height="25px">02:00</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank you for help.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 06 Dec 2023 19:31:24 GMT https://community.qlik.com/t5/App-Development/Calculating-employees-shift-time-work/m-p/2144985#M93168 krmvacar 2023-12-06T19:31:24Z Re: Calculating employees' shift time work https://community.qlik.com/t5/App-Development/Calculating-employees-shift-time-work/m-p/2144997#M93172 <P>Do you want to calc in the chart or the script? If in the chart, a clear way of expressing the rule might be:</P> <P class="p1"><FONT face="courier new,courier">Shıft_Hours<SPAN class="s1"> = 3 <BR /></SPAN><SPAN class="s2">or</SPAN><SPAN class="s1"> (</SPAN>Shıft_Hours<SPAN class="s1"> = 2 </SPAN><SPAN class="s2">and</SPAN> <SPAN class="s2">hour</SPAN><SPAN class="s1">(</SPAN>Fault_Time_start<SPAN class="s1">) &gt;= <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span><BR /></SPAN><SPAN class="s2">or</SPAN><SPAN class="s1"> ( </SPAN>Shıft_Hours<SPAN class="s1"> = 1 </SPAN><SPAN class="s2">and</SPAN> <SPAN class="s2">hour</SPAN><SPAN class="s1">(</SPAN>Fault_Time_start<SPAN class="s1">) &gt;= 8 </SPAN><SPAN class="s2">and</SPAN><SPAN class="s1"><SPAN class="Apple-converted-space">&nbsp; </SPAN></SPAN><SPAN class="s2">hour</SPAN><SPAN class="s1">(</SPAN>Fault_Time_start<SPAN class="s1">) &lt;= 16) </SPAN></FONT></P> <P class="p1"><SPAN class="s1">This assumes you are only concerned with if the fault started in the shift. You can use this with the fault time calculation measure like:</SPAN></P> <P class="p1"><FONT face="courier new,courier"><SPAN class="s1">(</SPAN>Fault_Time_End<SPAN class="s1"> - </SPAN>Fault_Time_start<SPAN class="s1">)<BR />* -(<BR /></SPAN>Shıft_Hours<SPAN class="s1"> = 3 <BR /></SPAN><SPAN class="s2">or</SPAN><SPAN class="s1"> (</SPAN>Shıft_Hours<SPAN class="s1"> = 2 </SPAN><SPAN class="s2">and</SPAN> <SPAN class="s2">hour</SPAN><SPAN class="s1">(</SPAN>Fault_Time_start<SPAN class="s1">) &gt;= <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span><BR /></SPAN><SPAN class="s2">or</SPAN><SPAN class="s1"> ( </SPAN>Shıft_Hours<SPAN class="s1"> = 1 </SPAN><SPAN class="s2">and</SPAN> <SPAN class="s2">hour</SPAN><SPAN class="s1">(</SPAN>Fault_Time_start<SPAN class="s1">) &gt;= 8 </SPAN><SPAN class="s2">and</SPAN><SPAN class="s1"><SPAN class="Apple-converted-space">&nbsp; </SPAN></SPAN><SPAN class="s2">hour</SPAN><SPAN class="s1">(</SPAN>Fault_Time_start</FONT><SPAN class="s1"><FONT face="courier new,courier">) &lt;= 16)</FONT><BR /><FONT face="courier new,courier">)</FONT> </SPAN></P> <P class="p1"><SPAN class="s1">-Rob<BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A></SPAN></P> Wed, 06 Dec 2023 20:14:13 GMT https://community.qlik.com/t5/App-Development/Calculating-employees-shift-time-work/m-p/2144997#M93172 rwunderlich 2023-12-06T20:14:13Z