topic Group by timestamp Dates in QlikView https://community.qlik.com/t5/QlikView/Group-by-timestamp-Dates/m-p/1535370#M600449 <P>Guys, hello</P><P>I have the following report from access system for the Staff and i need to make a control access application per day where i can sum total_hhmmss for each day and compare the field Total_hhmmss with the difference between date_entrance and date_exit for check if the report works properly.</P><TABLE><TBODY><TR><TD>name</TD><TD>total_hhmmss</TD><TD>date_entrance</TD><TD>date_exit</TD></TR><TR><TD>STAFF1</TD><TD>01:12:00</TD><TD>02/11/2018 16:25</TD><TD>02/11/2018 17:37</TD></TR><TR><TD>STAFF1</TD><TD>01:51:00</TD><TD>05/11/2018 16:10</TD><TD>05/11/2018 18:01</TD></TR><TR><TD>STAFF1</TD><TD>01:19:00</TD><TD>06/11/2018 16:08</TD><TD>06/11/2018 17:27</TD></TR><TR><TD>STAFF1</TD><TD>01:49:00</TD><TD>07/11/2018 16:04</TD><TD>07/11/2018 17:53</TD></TR><TR><TD>STAFF1</TD><TD>01:57:00</TD><TD>08/11/2018 16:08</TD><TD>08/11/2018 18:05</TD></TR><TR><TD>STAFF1</TD><TD>02:09:00</TD><TD>12/11/2018 16:07</TD><TD>12/11/2018 18:16</TD></TR><TR><TD>STAFF1</TD><TD>01:20:00</TD><TD>13/11/2018 16:26</TD><TD>13/11/2018 17:46</TD></TR><TR><TD>STAFF1</TD><TD>01:56:00</TD><TD>15/11/2018 16:10</TD><TD>15/11/2018 18:06</TD></TR><TR><TD>STAFF1</TD><TD>00:21:00</TD><TD>16/11/2018 16:05</TD><TD>16/11/2018 16:26</TD></TR><TR><TD>STAFF1</TD><TD>01:22:00</TD><TD>20/11/2018 16:04</TD><TD>20/11/2018 17:26</TD></TR><TR><TD><STRONG>STAFF1</STRONG></TD><TD><STRONG>01:29:00</STRONG></TD><TD><STRONG>21/11/2018 16:13</STRONG></TD><TD><STRONG>21/11/2018 17:42</STRONG></TD></TR><TR><TD><STRONG>STAFF1</STRONG></TD><TD><STRONG>00:12:00</STRONG></TD><TD><STRONG>21/11/2018 17:42</STRONG></TD><TD><STRONG>21/11/2018 17:54</STRONG></TD></TR><TR><TD>STAFF1</TD><TD>01:23:00</TD><TD>22/11/2018 16:09</TD><TD>22/11/2018 17:32</TD></TR><TR><TD>STAFF1</TD><TD>01:58:00</TD><TD>26/11/2018 16:08</TD><TD>26/11/2018 18:06</TD></TR><TR><TD>STAFF1</TD><TD>01:24:00</TD><TD>03/12/2018 16:26</TD><TD>03/12/2018 17:50</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Thanks!</P> Sat, 16 Nov 2024 04:39:25 GMT jumiprado 2024-11-16T04:39:25Z Group by timestamp Dates https://community.qlik.com/t5/QlikView/Group-by-timestamp-Dates/m-p/1535370#M600449 <P>Guys, hello</P><P>I have the following report from access system for the Staff and i need to make a control access application per day where i can sum total_hhmmss for each day and compare the field Total_hhmmss with the difference between date_entrance and date_exit for check if the report works properly.</P><TABLE><TBODY><TR><TD>name</TD><TD>total_hhmmss</TD><TD>date_entrance</TD><TD>date_exit</TD></TR><TR><TD>STAFF1</TD><TD>01:12:00</TD><TD>02/11/2018 16:25</TD><TD>02/11/2018 17:37</TD></TR><TR><TD>STAFF1</TD><TD>01:51:00</TD><TD>05/11/2018 16:10</TD><TD>05/11/2018 18:01</TD></TR><TR><TD>STAFF1</TD><TD>01:19:00</TD><TD>06/11/2018 16:08</TD><TD>06/11/2018 17:27</TD></TR><TR><TD>STAFF1</TD><TD>01:49:00</TD><TD>07/11/2018 16:04</TD><TD>07/11/2018 17:53</TD></TR><TR><TD>STAFF1</TD><TD>01:57:00</TD><TD>08/11/2018 16:08</TD><TD>08/11/2018 18:05</TD></TR><TR><TD>STAFF1</TD><TD>02:09:00</TD><TD>12/11/2018 16:07</TD><TD>12/11/2018 18:16</TD></TR><TR><TD>STAFF1</TD><TD>01:20:00</TD><TD>13/11/2018 16:26</TD><TD>13/11/2018 17:46</TD></TR><TR><TD>STAFF1</TD><TD>01:56:00</TD><TD>15/11/2018 16:10</TD><TD>15/11/2018 18:06</TD></TR><TR><TD>STAFF1</TD><TD>00:21:00</TD><TD>16/11/2018 16:05</TD><TD>16/11/2018 16:26</TD></TR><TR><TD>STAFF1</TD><TD>01:22:00</TD><TD>20/11/2018 16:04</TD><TD>20/11/2018 17:26</TD></TR><TR><TD><STRONG>STAFF1</STRONG></TD><TD><STRONG>01:29:00</STRONG></TD><TD><STRONG>21/11/2018 16:13</STRONG></TD><TD><STRONG>21/11/2018 17:42</STRONG></TD></TR><TR><TD><STRONG>STAFF1</STRONG></TD><TD><STRONG>00:12:00</STRONG></TD><TD><STRONG>21/11/2018 17:42</STRONG></TD><TD><STRONG>21/11/2018 17:54</STRONG></TD></TR><TR><TD>STAFF1</TD><TD>01:23:00</TD><TD>22/11/2018 16:09</TD><TD>22/11/2018 17:32</TD></TR><TR><TD>STAFF1</TD><TD>01:58:00</TD><TD>26/11/2018 16:08</TD><TD>26/11/2018 18:06</TD></TR><TR><TD>STAFF1</TD><TD>01:24:00</TD><TD>03/12/2018 16:26</TD><TD>03/12/2018 17:50</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Thanks!</P> Sat, 16 Nov 2024 04:39:25 GMT https://community.qlik.com/t5/QlikView/Group-by-timestamp-Dates/m-p/1535370#M600449 jumiprado 2024-11-16T04:39:25Z Re: Group by timestamp Dates https://community.qlik.com/t5/QlikView/Group-by-timestamp-Dates/m-p/1535406#M600450 <P>Could you provide the preferred result from your row data?</P><P>Thank you</P> Fri, 25 Jan 2019 19:25:54 GMT https://community.qlik.com/t5/QlikView/Group-by-timestamp-Dates/m-p/1535406#M600450 MindaugasBacius 2019-01-25T19:25:54Z Re: Group by timestamp Dates https://community.qlik.com/t5/QlikView/Group-by-timestamp-Dates/m-p/1535890#M600451 <P>I need something like this:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>name</TD><TD>date_entrance</TD><TD>date_exit</TD><TD><STRONG>Date_Entrance2</STRONG></TD><TD><STRONG>Date_Exit2</STRONG></TD><TD>total_hhmmss</TD><TD><STRONG>Dif Between Timestamp</STRONG></TD></TR><TR><TD>STAFF1</TD><TD>02/11/2018 16:25</TD><TD>02/11/2018 17:37</TD><TD>02/11/2018</TD><TD>02/11/2018</TD><TD>01:12:00</TD><TD>01:12:00</TD></TR><TR><TD>STAFF1</TD><TD>05/11/2018 16:10</TD><TD>05/11/2018 18:01</TD><TD>05/11/2018</TD><TD>05/11/2018</TD><TD>01:51:00</TD><TD>01:51:00</TD></TR><TR><TD>STAFF1</TD><TD>06/11/2018 16:08</TD><TD>06/11/2018 17:27</TD><TD>06/11/2018</TD><TD>06/11/2018</TD><TD>01:19:00</TD><TD>01:19:00</TD></TR><TR><TD>STAFF1</TD><TD>07/11/2018 16:04</TD><TD>07/11/2018 17:53</TD><TD>07/11/2018</TD><TD>07/11/2018</TD><TD>01:49:00</TD><TD>01:49:00</TD></TR><TR><TD>STAFF1</TD><TD>08/11/2018 16:08</TD><TD>08/11/2018 18:05</TD><TD>08/11/2018</TD><TD>08/11/2018</TD><TD>01:57:00</TD><TD>01:57:00</TD></TR><TR><TD>STAFF1</TD><TD>12/11/2018 16:07</TD><TD>12/11/2018 18:16</TD><TD>12/11/2018</TD><TD>12/11/2018</TD><TD>02:09:00</TD><TD>02:09:00</TD></TR><TR><TD>STAFF1</TD><TD>13/11/2018 16:26</TD><TD>13/11/2018 17:46</TD><TD>13/11/2018</TD><TD>13/11/2018</TD><TD>01:20:00</TD><TD>01:20:00</TD></TR><TR><TD>STAFF1</TD><TD>15/11/2018 16:10</TD><TD>15/11/2018 18:06</TD><TD>15/11/2018</TD><TD>15/11/2018</TD><TD>01:56:00</TD><TD>01:56:00</TD></TR><TR><TD>STAFF1</TD><TD>16/11/2018 16:05</TD><TD>16/11/2018 16:26</TD><TD>16/11/2018</TD><TD>16/11/2018</TD><TD>00:21:00</TD><TD>00:21:00</TD></TR><TR><TD>STAFF1</TD><TD>20/11/2018 16:04</TD><TD>20/11/2018 17:26</TD><TD>20/11/2018</TD><TD>20/11/2018</TD><TD>01:22:00</TD><TD>01:22:00</TD></TR><TR><TD><FONT color="#FF0000">STAFF1</FONT></TD><TD><FONT color="#FF0000">21/11/2018 16:13</FONT></TD><TD><FONT color="#FF0000">21/11/2018 17:42</FONT></TD><TD><FONT color="#FF0000">21/11/2018</FONT></TD><TD><FONT color="#FF0000">21/11/2018</FONT></TD><TD><FONT color="#FF0000">01:35:00</FONT></TD><TD><FONT color="#FF0000">01:29:00</FONT></TD></TR><TR><TD><FONT color="#FF0000">STAFF1</FONT></TD><TD><FONT color="#FF0000">21/11/2018 17:42</FONT></TD><TD><FONT color="#FF0000">21/11/2018 17:54</FONT></TD><TD><FONT color="#FF0000">21/11/2018</FONT></TD><TD><FONT color="#FF0000">21/11/2018</FONT></TD><TD><FONT color="#FF0000">01:35:00</FONT></TD><TD><FONT color="#FF0000">00:12:00</FONT></TD></TR><TR><TD>STAFF1</TD><TD>22/11/2018 16:09</TD><TD>22/11/2018 17:32</TD><TD>22/11/2018</TD><TD>22/11/2018</TD><TD>01:23:00</TD><TD>01:23:00</TD></TR><TR><TD>STAFF1</TD><TD>26/11/2018 16:08</TD><TD>26/11/2018 18:06</TD><TD>26/11/2018</TD><TD>26/11/2018</TD><TD>01:58:00</TD><TD>01:58:00</TD></TR><TR><TD>STAFF1</TD><TD>03/12/2018 16:26</TD><TD>03/12/2018 17:50</TD><TD>03/12/2018</TD><TD>03/12/2018</TD><TD>01:24:00</TD><TD>01:24:00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>thanks!</P> Mon, 28 Jan 2019 12:38:56 GMT https://community.qlik.com/t5/QlikView/Group-by-timestamp-Dates/m-p/1535890#M600451 jumiprado 2019-01-28T12:38:56Z