topic Re: start and end time with hirarchy in QlikView https://community.qlik.com/t5/QlikView/start-and-end-time-with-hirarchy/m-p/1605116#M597550 <P>Thanks a lot Petter, Worked well&nbsp;</P> Tue, 23 Jul 2019 11:51:20 GMT vpanchuda 2019-07-23T11:51:20Z start and end time with hirarchy https://community.qlik.com/t5/QlikView/start-and-end-time-with-hirarchy/m-p/1603687#M597547 <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> Thu, 18 Jul 2019 12:54:53 GMT https://community.qlik.com/t5/QlikView/start-and-end-time-with-hirarchy/m-p/1603687#M597547 vpanchuda 2019-07-18T12:54:53Z Re: start and end time with hirarchy https://community.qlik.com/t5/QlikView/start-and-end-time-with-hirarchy/m-p/1604249#M597549 <P><FONT color="#339966"><STRONG>[ NOTE: to show any contributor that you like and appreciate their answers please CLICK the like icon (thumbs up) ]</STRONG></FONT></P><P>Here's a way to do it:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Merknad 2019-07-19 173209.png" style="width: 939px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/15742i68640DB25A202CE8/image-dimensions/939x525?v=v2" width="939" height="525" role="button" title="Merknad 2019-07-19 173209.png" alt="Merknad 2019-07-19 173209.png" /></span></P> Fri, 19 Jul 2019 17:35:06 GMT https://community.qlik.com/t5/QlikView/start-and-end-time-with-hirarchy/m-p/1604249#M597549 petter 2019-07-19T17:35:06Z Re: start and end time with hirarchy https://community.qlik.com/t5/QlikView/start-and-end-time-with-hirarchy/m-p/1605116#M597550 <P>Thanks a lot Petter, Worked well&nbsp;</P> Tue, 23 Jul 2019 11:51:20 GMT https://community.qlik.com/t5/QlikView/start-and-end-time-with-hirarchy/m-p/1605116#M597550 vpanchuda 2019-07-23T11:51:20Z