topic Interval Calculations in QlikView https://community.qlik.com/t5/QlikView/Interval-Calculations/m-p/927890#M321061 <HTML><HEAD></HEAD><BODY><P>Hi All;</P><P></P><P>Please see attached my data source.</P><P>I calculated my loading duration as follows:</P><P> Interval( [First Pick Departure Date]-[First Pick Arrival Date],'mm') as<STRONG> LoadingDuration</STRONG></P><P></P><P>I now want my model to say if <SPAN style="font-size: 13.3333px;"><STRONG>[First Pick Arrival Date]</STRONG> has a time greater than or equal to 17H00 but less than 23H59 then let <SPAN style="font-size: 13.3333px;"><STRONG>[First Pick Arrival Date]</STRONG> be the following day at 08H00. If <SPAN style="font-size: 13.3333px;"><STRONG>[First Pick Arrival Date]</STRONG> has a time between 00H00 and less than 08H00 then change time on <SPAN style="font-size: 13.3333px;"><STRONG>[First Pick Arrival Date]</STRONG> field to be 08H00 but the date will remain the same.</SPAN></SPAN></SPAN></SPAN></P><P></P><P>In other words if a truck arrives when the loading site is closed, l want my model to use 08H00 when the loading site is open to calculate the <STRONG>LoadingDuration</STRONG> field.</P><P></P><P>Please assist.</P><P></P><P>Regards;</P><P></P><P>Moses</P></BODY></HTML> Wed, 18 Nov 2015 07:41:16 GMT 2015-11-18T07:41:16Z Interval Calculations https://community.qlik.com/t5/QlikView/Interval-Calculations/m-p/927890#M321061 <HTML><HEAD></HEAD><BODY><P>Hi All;</P><P></P><P>Please see attached my data source.</P><P>I calculated my loading duration as follows:</P><P> Interval( [First Pick Departure Date]-[First Pick Arrival Date],'mm') as<STRONG> LoadingDuration</STRONG></P><P></P><P>I now want my model to say if <SPAN style="font-size: 13.3333px;"><STRONG>[First Pick Arrival Date]</STRONG> has a time greater than or equal to 17H00 but less than 23H59 then let <SPAN style="font-size: 13.3333px;"><STRONG>[First Pick Arrival Date]</STRONG> be the following day at 08H00. If <SPAN style="font-size: 13.3333px;"><STRONG>[First Pick Arrival Date]</STRONG> has a time between 00H00 and less than 08H00 then change time on <SPAN style="font-size: 13.3333px;"><STRONG>[First Pick Arrival Date]</STRONG> field to be 08H00 but the date will remain the same.</SPAN></SPAN></SPAN></SPAN></P><P></P><P>In other words if a truck arrives when the loading site is closed, l want my model to use 08H00 when the loading site is open to calculate the <STRONG>LoadingDuration</STRONG> field.</P><P></P><P>Please assist.</P><P></P><P>Regards;</P><P></P><P>Moses</P></BODY></HTML> Wed, 18 Nov 2015 07:41:16 GMT https://community.qlik.com/t5/QlikView/Interval-Calculations/m-p/927890#M321061 2015-11-18T07:41:16Z Re: Interval Calculations https://community.qlik.com/t5/QlikView/Interval-Calculations/m-p/927891#M321062 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Wed, 18 Nov 2015 10:03:05 GMT https://community.qlik.com/t5/QlikView/Interval-Calculations/m-p/927891#M321062 Gysbert_Wassenaar 2015-11-18T10:03:05Z Re: Interval Calculations https://community.qlik.com/t5/QlikView/Interval-Calculations/m-p/927892#M321063 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert!</P></BODY></HTML> Wed, 18 Nov 2015 14:32:17 GMT https://community.qlik.com/t5/QlikView/Interval-Calculations/m-p/927892#M321063 2015-11-18T14:32:17Z