topic Lapse Age calculation in date range in QlikView https://community.qlik.com/t5/QlikView/Lapse-Age-calculation-in-date-range/m-p/208880#M64085 <HTML><HEAD></HEAD><BODY><P>Hi,<BR /><BR /> Not sure I understand fully however........<BR /><BR />Can you grab the MIN(VisitDate) and the MAX(VisitDate) for a person to derive their lapse....If the two are the same they have never visited again after their first visit.<BR /><BR />Cheers.</P><P>Ad.</P></BODY></HTML> Thu, 08 Oct 2009 21:28:04 GMT Anonymous 2009-10-08T21:28:04Z Lapse Age calculation in date range https://community.qlik.com/t5/QlikView/Lapse-Age-calculation-in-date-range/m-p/208879#M64084 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am trying to calculate Lapse date(one person visited in 2005 and never visited till 2009, he is lapsed from 2005 etc). how to get the logic in qlikview. I have id, datevisited in each of the year. I am trying to find the person who visited once in 2005 and never visited, then one person visited in 2006 and never visisted again. Anybody please guide me on this. Thanks!</P><P>Prasad</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-487_sourceID:487" /></P></BODY></HTML> Wed, 07 Oct 2009 16:47:53 GMT https://community.qlik.com/t5/QlikView/Lapse-Age-calculation-in-date-range/m-p/208879#M64084 prasad 2009-10-07T16:47:53Z Lapse Age calculation in date range https://community.qlik.com/t5/QlikView/Lapse-Age-calculation-in-date-range/m-p/208880#M64085 <HTML><HEAD></HEAD><BODY><P>Hi,<BR /><BR /> Not sure I understand fully however........<BR /><BR />Can you grab the MIN(VisitDate) and the MAX(VisitDate) for a person to derive their lapse....If the two are the same they have never visited again after their first visit.<BR /><BR />Cheers.</P><P>Ad.</P></BODY></HTML> Thu, 08 Oct 2009 21:28:04 GMT https://community.qlik.com/t5/QlikView/Lapse-Age-calculation-in-date-range/m-p/208880#M64085 Anonymous 2009-10-08T21:28:04Z Lapse Age calculation in date range https://community.qlik.com/t5/QlikView/Lapse-Age-calculation-in-date-range/m-p/208881#M64086 <HTML><HEAD></HEAD><BODY><P>Thanks for the info. I was able to resolve this by getting the last visit date. Thanks! Again</P><P>Prasad</P></BODY></HTML> Fri, 09 Oct 2009 14:28:01 GMT https://community.qlik.com/t5/QlikView/Lapse-Age-calculation-in-date-range/m-p/208881#M64086 prasad 2009-10-09T14:28:01Z