Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Date of Last Visit Problem

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.


Tags (3)