Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display most recent record before a date

I've got a straight table displaying records within a given date range.  I would like to display ONLY the latest record prior to a user-defned "as of date". To identify this record, tried:

If(Aggr(NODISTINCT Max({<EFFECTIVE_START_DATE={"<=$(=vAsOfDate)"}>} EFFECTIVE_START_DATE), EMPLOYEE_NUMBER) = EFFECTIVE_START_DATE, 1,null()),

However, all records return a null.  I'm not sure that my set expression in the MAX function is correct.  Any assistance would be appreciated.

1 Reply
sunny_talwar

Would you be able to share some sample data points with your desired output?