topic Mean time between repairs.. in QlikView https://community.qlik.com/t5/QlikView/Mean-time-between-repairs/m-p/142849#M22240 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am struggling with the following problem..</P><P>I've got a table containing repairs.. Every records contains a unique repairordernumber, a serialnumber and a orderdate. I would like to calculate the number of days between repairs of each serialnumber. Can someone tell me how to script this?</P><P>Thanks, Sander</P></BODY></HTML> Wed, 29 Apr 2009 22:06:26 GMT 2009-04-29T22:06:26Z Mean time between repairs.. https://community.qlik.com/t5/QlikView/Mean-time-between-repairs/m-p/142849#M22240 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am struggling with the following problem..</P><P>I've got a table containing repairs.. Every records contains a unique repairordernumber, a serialnumber and a orderdate. I would like to calculate the number of days between repairs of each serialnumber. Can someone tell me how to script this?</P><P>Thanks, Sander</P></BODY></HTML> Wed, 29 Apr 2009 22:06:26 GMT https://community.qlik.com/t5/QlikView/Mean-time-between-repairs/m-p/142849#M22240 2009-04-29T22:06:26Z Mean time between repairs.. https://community.qlik.com/t5/QlikView/Mean-time-between-repairs/m-p/142850#M22241 <HTML><HEAD></HEAD><BODY><P>Something like:</P><P>RIGHT JOIN LOAD DISTINCT *,<BR />if(peek('repairordernumber') = repairordernumber, orderdate - peek('orderdate'), 0) as daysBetween<BR />RESIDENT repairs<BR />ORDER BY repairordernumber, orderdate;</P><P>-Rob</P></BODY></HTML> Wed, 29 Apr 2009 23:17:41 GMT https://community.qlik.com/t5/QlikView/Mean-time-between-repairs/m-p/142850#M22241 rwunderlich 2009-04-29T23:17:41Z