topic Start and end time in QlikView https://community.qlik.com/t5/QlikView/Start-and-end-time/m-p/1603676#M597566 <P>HI&nbsp;</P><P>Can someone please help me with below requirement Logic and function to be used.</P><P>I need to filter by JOB and Task with start and end time for JO&nbsp; and event respectively.</P><P>Log Table:</P><TABLE><TBODY><TR><TD>date</TD><TD>time</TD><TD>Event</TD></TR><TR><TD>15-07-2019</TD><TD>1.00 Am</TD><TD>Job Start:Turning</TD></TR><TR><TD>15-07-2019</TD><TD>2.00 Am</TD><TD>Task Start: Turning Componrnt 1 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>2.30 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>2.40 Am</TD><TD>Machining</TD></TR><TR><TD>15-07-2019</TD><TD>3.00 Am</TD><TD>Task End: Turning Componrnt 1 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>3.30 Am</TD><TD>Task Start: Turning Componrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>4.00 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>5.00 Am</TD><TD>Machining</TD></TR><TR><TD>15-07-2019</TD><TD>5.15 Am</TD><TD>Task End:Turning Componrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>5.55 Am</TD><TD>Job End: Turning</TD></TR><TR><TD>15-07-2019</TD><TD>6.12 Am</TD><TD>Job Start:Milling</TD></TR><TR><TD>15-07-2019</TD><TD>6.30 Am</TD><TD>Task Start: Milling Componrnt 1 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>7.00 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>7.20 Am</TD><TD>Machining</TD></TR><TR><TD>15-07-2019</TD><TD>7.25 Am</TD><TD>Task End:Milling Componrnt 1 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>7.40 Am</TD><TD>Task Start: Milling Componrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>7.50 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>8.05 Am</TD><TD>Machining</TD></TR><TR><TD>15-07-2019</TD><TD>8.15 Am</TD><TD>Task End: Milling Componrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>8.18 Am</TD><TD>Job End: Milling</TD></TR><TR><TD>15-07-2019</TD><TD>8.30 Am</TD><TD>Job Start :Cleaning</TD></TR><TR><TD>15-07-2019</TD><TD>8.35 AM</TD><TD>Task Start: CleaningComponrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>8.40 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Cleaning</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Task End: CleaningComponrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Job End:Cleaning</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to get table similar so that i can filter in the front end by Job and Task</P><TABLE><TBODY><TR><TD>date</TD><TD>time</TD><TD>Event</TD><TD>JOB</TD><TD>Start Time</TD><TD>End Time</TD></TR><TR><TD>15-07-2019</TD><TD>1.00 Am</TD><TD>Job Start:Turning</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>2.00 Am</TD><TD>Task Start: Turning Componrnt 1 load tool</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>2.30 Am</TD><TD>tool loaded</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>2.40 Am</TD><TD>Machining</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>3.00 Am</TD><TD>Task End: Turning Componrnt 1 load tool</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>3.30 Am</TD><TD>Task Start: Turning Componrnt 2 load tool</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>4.00 Am</TD><TD>tool loaded</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>5.00 Am</TD><TD>Machining</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>5.15 Am</TD><TD>Task End:Turning Componrnt 2 load tool</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>5.55 Am</TD><TD>Job End: Turning</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>6.12 Am</TD><TD>Job Start:Milling</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>6.30 Am</TD><TD>Task Start: Milling Componrnt 1 load tool</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.00 Am</TD><TD>tool loaded</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.20 Am</TD><TD>Machining</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.25 Am</TD><TD>Task End:Milling Componrnt 1 load tool</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.40 Am</TD><TD>Task Start: Milling Componrnt 2 load tool</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.50 Am</TD><TD>tool loaded</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.05 Am</TD><TD>Machining</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.15 Am</TD><TD>Task End: Milling Component 2 load tool</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.18 Am</TD><TD>Job End: Milling</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.30 Am</TD><TD>Job Start :Cleaning</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.35 AM</TD><TD>Task Start: CleaningComponrnt 2 load tool</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.40 Am</TD><TD>tool loaded</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Cleaning</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Task End: CleaningComponrnt 2 load tool</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Job End:Cleaning</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 20:25:34 GMT vpanchuda 2024-11-16T20:25:34Z Start and end time https://community.qlik.com/t5/QlikView/Start-and-end-time/m-p/1603676#M597566 <P>HI&nbsp;</P><P>Can someone please help me with below requirement Logic and function to be used.</P><P>I need to filter by JOB and Task with start and end time for JO&nbsp; and event respectively.</P><P>Log Table:</P><TABLE><TBODY><TR><TD>date</TD><TD>time</TD><TD>Event</TD></TR><TR><TD>15-07-2019</TD><TD>1.00 Am</TD><TD>Job Start:Turning</TD></TR><TR><TD>15-07-2019</TD><TD>2.00 Am</TD><TD>Task Start: Turning Componrnt 1 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>2.30 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>2.40 Am</TD><TD>Machining</TD></TR><TR><TD>15-07-2019</TD><TD>3.00 Am</TD><TD>Task End: Turning Componrnt 1 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>3.30 Am</TD><TD>Task Start: Turning Componrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>4.00 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>5.00 Am</TD><TD>Machining</TD></TR><TR><TD>15-07-2019</TD><TD>5.15 Am</TD><TD>Task End:Turning Componrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>5.55 Am</TD><TD>Job End: Turning</TD></TR><TR><TD>15-07-2019</TD><TD>6.12 Am</TD><TD>Job Start:Milling</TD></TR><TR><TD>15-07-2019</TD><TD>6.30 Am</TD><TD>Task Start: Milling Componrnt 1 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>7.00 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>7.20 Am</TD><TD>Machining</TD></TR><TR><TD>15-07-2019</TD><TD>7.25 Am</TD><TD>Task End:Milling Componrnt 1 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>7.40 Am</TD><TD>Task Start: Milling Componrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>7.50 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>8.05 Am</TD><TD>Machining</TD></TR><TR><TD>15-07-2019</TD><TD>8.15 Am</TD><TD>Task End: Milling Componrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>8.18 Am</TD><TD>Job End: Milling</TD></TR><TR><TD>15-07-2019</TD><TD>8.30 Am</TD><TD>Job Start :Cleaning</TD></TR><TR><TD>15-07-2019</TD><TD>8.35 AM</TD><TD>Task Start: CleaningComponrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>8.40 Am</TD><TD>tool loaded</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Cleaning</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Task End: CleaningComponrnt 2 load tool</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Job End:Cleaning</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to get table similar so that i can filter in the front end by Job and Task</P><TABLE><TBODY><TR><TD>date</TD><TD>time</TD><TD>Event</TD><TD>JOB</TD><TD>Start Time</TD><TD>End Time</TD></TR><TR><TD>15-07-2019</TD><TD>1.00 Am</TD><TD>Job Start:Turning</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>2.00 Am</TD><TD>Task Start: Turning Componrnt 1 load tool</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>2.30 Am</TD><TD>tool loaded</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>2.40 Am</TD><TD>Machining</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>3.00 Am</TD><TD>Task End: Turning Componrnt 1 load tool</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>3.30 Am</TD><TD>Task Start: Turning Componrnt 2 load tool</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>4.00 Am</TD><TD>tool loaded</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>5.00 Am</TD><TD>Machining</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>5.15 Am</TD><TD>Task End:Turning Componrnt 2 load tool</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>5.55 Am</TD><TD>Job End: Turning</TD><TD>Turning</TD><TD>1.00 Am</TD><TD>5.55 Am</TD></TR><TR><TD>15-07-2019</TD><TD>6.12 Am</TD><TD>Job Start:Milling</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>6.30 Am</TD><TD>Task Start: Milling Componrnt 1 load tool</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.00 Am</TD><TD>tool loaded</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.20 Am</TD><TD>Machining</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.25 Am</TD><TD>Task End:Milling Componrnt 1 load tool</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.40 Am</TD><TD>Task Start: Milling Componrnt 2 load tool</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>7.50 Am</TD><TD>tool loaded</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.05 Am</TD><TD>Machining</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.15 Am</TD><TD>Task End: Milling Component 2 load tool</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.18 Am</TD><TD>Job End: Milling</TD><TD>Milling</TD><TD>6.12 Am</TD><TD>8.18 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.30 Am</TD><TD>Job Start :Cleaning</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.35 AM</TD><TD>Task Start: CleaningComponrnt 2 load tool</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.40 Am</TD><TD>tool loaded</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Cleaning</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Task End: CleaningComponrnt 2 load tool</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR><TR><TD>15-07-2019</TD><TD>8.45 Am</TD><TD>Job End:Cleaning</TD><TD>Cleaning</TD><TD>8.30 Am</TD><TD>8.45 Am</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 20:25:34 GMT https://community.qlik.com/t5/QlikView/Start-and-end-time/m-p/1603676#M597566 vpanchuda 2024-11-16T20:25:34Z Re: Start and end time https://community.qlik.com/t5/QlikView/Start-and-end-time/m-p/1612123#M597567 <P>Duplicate post, see the following post for solution details:</P> <P><A href="https://community.qlik.com/t5/QlikView-Scripting/start-and-end-time-with-hirarchy/m-p/1603687#M95947" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/start-and-end-time-with-hirarchy/m-p/1603687#M95947</A></P> <P>Regards,<BR />Brett</P> Tue, 13 Aug 2019 17:56:02 GMT https://community.qlik.com/t5/QlikView/Start-and-end-time/m-p/1612123#M597567 Brett_Bleess 2019-08-13T17:56:02Z