topic Re: Start and end time wrt To event for changing Dimension in App Development https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1605117#M44786 <P>Thank you for the reply.</P><P>Grouped the job using Row num and Peek function , made a different table for end time and it worked got helped by Petter in the community.</P> Tue, 23 Jul 2019 11:54:02 GMT vpanchuda 2019-07-23T11:54:02Z Start and end time wrt To event for changing Dimension https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1603524#M44674 <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 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>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><P>&nbsp;</P> Sat, 16 Nov 2024 20:25:56 GMT https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1603524#M44674 vpanchuda 2024-11-16T20:25:56Z Re: Start and end time wrt To event for changing Dimension https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1604855#M44768 <P>Have you tried calculating start and end time during the data load? Assuming only one JOB runs at a time...</P> Mon, 22 Jul 2019 21:06:21 GMT https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1604855#M44768 Lauri 2019-07-22T21:06:21Z Re: Start and end time wrt To event for changing Dimension https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1604937#M44775 <P>Hi ,</P><P>I would say&nbsp; do group by Job and take MinDate(with timestamp ) as Start date&nbsp; and MaxDate(with timestamp) as EndDate, and take start time from start date and End time from EndDate&nbsp;</P> Tue, 23 Jul 2019 06:43:27 GMT https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1604937#M44775 mahaveerbiraj 2019-07-23T06:43:27Z Re: Start and end time wrt To event for changing Dimension https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1605117#M44786 <P>Thank you for the reply.</P><P>Grouped the job using Row num and Peek function , made a different table for end time and it worked got helped by Petter in the community.</P> Tue, 23 Jul 2019 11:54:02 GMT https://community.qlik.com/t5/App-Development/Start-and-end-time-wrt-To-event-for-changing-Dimension/m-p/1605117#M44786 vpanchuda 2019-07-23T11:54:02Z