Lapse Age calculation in date range

[prasad]

Hi All,

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!

Prasad

[Anonymous]

Hi,

Not sure I understand fully however........

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.

Cheers.

Ad.

[prasad · Accepted solution]

Thanks for the info. I was able to resolve this by getting the last visit date. Thanks! Again

Prasad