Hi Guys,
I'm trying to compute the Date of Last Visit column. Currently my data contains Userid and Date columns and I have calculate the Date of Last Visit. To do this I have to look at each user and find the last Date of Visit. In User1 for Date 1/30 his last visit date is 1/26. Similarly User1 for Date 1/26 his last visit date is 1/25. For User1 and 1/24 he won't have last visit date because we don't that historical record. Is this doable in QV? Not sure how to do this lookup.
Please advise.
Thanks for your time.
V.