0 Replies Latest reply: Mar 24, 2015 1:27 PM by Vishal Jada RSS

    Date of Last Visit Problem

    Vishal Jada

      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.