set analysis expression to return most recent records from selected date(Month Year)

[shawnqlikfv]

Hello,

I'm FOB (Fresh Off the Boat) with Qlikview. I'm really struggling understanding the concept with the set analysis and how it works. I have a list of records below. If I select the end date of April 2010, I would want a list of customers with max(order_date) <= April 2010. Can someone help ? Thanks in advance.

customer	order Date	product
a	2-Jan-10	XYZ
a	5-Mar-10	ABC	end date	April 2010
b	11-Jun-10	YYY	end date	July 2010
b	15-Apr-10	XYZ
c	19-Mar-10	XYZ
c	13-May-10	ABC