https://community.qlik.com/t5/QlikView/How-to-get-the-return-time/m-p/219544#M72561 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please check answer on attachment.</P><P>I created two differente expression to solve it. I prefer the second one, because you could see the global results.</P><P></P><P>Hope it helps,</P><P>Rgds,</P></BODY></HTML> Mon, 18 Apr 2011 04:35:55 GMT erichshiino 2011-04-18T04:35:55Z https://community.qlik.com/t5/QlikView/How-to-get-the-return-time/m-p/219543#M72560 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have the following records:</P><P>LOAD * Inline<BR />[Region,MemberId, BuyDate<BR />Brazil,1,2010/10/01<BR />Brazil,1,2010/10/05<BR />Brazil,1,2010/10/10<BR />Brazil,2,2010/11/01<BR />Brazil,2,2010/11/03<BR />]</P><P>Now I want to calculate after how many average days, the member will get back and but a new product.</P><P>And the results are divided by Region, MemberId</P><P>It looks like this:</P><P>Region, MemberId, Average Days</P><P>Brazil, 1 ,(4+5)/2</P><P>Brazil, 2, 2/1</P><P></P><P>How to calculate that average days?</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 18 Apr 2011 04:01:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-return-time/m-p/219543#M72560 2011-04-18T04:01:43Z https://community.qlik.com/t5/QlikView/How-to-get-the-return-time/m-p/219544#M72561 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please check answer on attachment.</P><P>I created two differente expression to solve it. I prefer the second one, because you could see the global results.</P><P></P><P>Hope it helps,</P><P>Rgds,</P></BODY></HTML> Mon, 18 Apr 2011 04:35:55 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-return-time/m-p/219544#M72561 erichshiino 2011-04-18T04:35:55Z