topic Re: Calculate time between product changes in QlikView https://community.qlik.com/t5/QlikView/Calculate-time-between-product-changes/m-p/723845#M259727 <HTML><HEAD></HEAD><BODY><P>you could use the below expression with Cutplan and date in dimension.</P><P>Max(Time)-Min(Time)</P></BODY></HTML> Wed, 29 Oct 2014 15:00:57 GMT 2014-10-29T15:00:57Z Calculate time between product changes https://community.qlik.com/t5/QlikView/Calculate-time-between-product-changes/m-p/723843#M259725 <HTML><HEAD></HEAD><BODY><P>I work at a lumber company and I need to calculate the time between Cut Plan changes. Example data is below. What I want to do is calculate the time between changes. For example, I need to subtract 7:05:24 AM from 8:55:35 AM to know how long my Cutplan 3 ran until it changed. Then I would need to subtract 10:47:23 AM from 12:30:10 PM to calculate my Plyblock run. Is this possible?</P><P></P><P>CutPlan&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Time</P><P>Plyblock&nbsp;&nbsp;&nbsp;&nbsp; 10/20/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7:00:00 AM</P><P>Cutplan3&nbsp;&nbsp;&nbsp; 10/20/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7:05:24 AM</P><P>Cutplan3&nbsp;&nbsp;&nbsp; 10/20/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8:50:48 AM</P><P>Cutplan3&nbsp;&nbsp;&nbsp; 10/20/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8:55:35 AM</P><P>Plyblock&nbsp;&nbsp;&nbsp;&nbsp; 10/20/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:47:23 AM</P><P>Plyblock&nbsp;&nbsp;&nbsp;&nbsp; 10/20/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11:15:55 AM</P><P>Plyblock&nbsp;&nbsp;&nbsp;&nbsp; 10/20/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12:30:10 PM</P><P>Cutplan 3&nbsp;&nbsp; 10/20/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12:50:15 PM</P></BODY></HTML> Wed, 29 Oct 2014 14:48:48 GMT https://community.qlik.com/t5/QlikView/Calculate-time-between-product-changes/m-p/723843#M259725 akile002 2014-10-29T14:48:48Z Re: Calculate time between product changes https://community.qlik.com/t5/QlikView/Calculate-time-between-product-changes/m-p/723844#M259726 <HTML><HEAD></HEAD><BODY><P>The interval() function allows you to calculate time differences.</P></BODY></HTML> Wed, 29 Oct 2014 14:54:50 GMT https://community.qlik.com/t5/QlikView/Calculate-time-between-product-changes/m-p/723844#M259726 Colin-Albert 2014-10-29T14:54:50Z Re: Calculate time between product changes https://community.qlik.com/t5/QlikView/Calculate-time-between-product-changes/m-p/723845#M259727 <HTML><HEAD></HEAD><BODY><P>you could use the below expression with Cutplan and date in dimension.</P><P>Max(Time)-Min(Time)</P></BODY></HTML> Wed, 29 Oct 2014 15:00:57 GMT https://community.qlik.com/t5/QlikView/Calculate-time-between-product-changes/m-p/723845#M259727 2014-10-29T15:00:57Z