Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks for the info. I was able to resolve this by getting the last visit date. Thanks! Again
Prasad
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.
Thanks for the info. I was able to resolve this by getting the last visit date. Thanks! Again
Prasad