topic Re: Display most recent record before a date in QlikView https://community.qlik.com/t5/QlikView/Display-most-recent-record-before-a-date/m-p/1092748#M466785 <HTML><HEAD></HEAD><BODY><P>Would you be able to share some sample data points with your desired output?</P></BODY></HTML> Thu, 14 Jan 2016 20:04:55 GMT sunny_talwar 2016-01-14T20:04:55Z Display most recent record before a date https://community.qlik.com/t5/QlikView/Display-most-recent-record-before-a-date/m-p/1092747#M466784 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">I've got a straight table displaying records within a given date range.&nbsp; I would like to display ONLY the latest record prior to a user-defned "as of date". To identify this record, tried:</P><P style="font-size: 13.3333px;"> If(Aggr(NODISTINCT Max({&lt;EFFECTIVE_START_DATE={"&lt;=$(=vAsOfDate)"}&gt;} EFFECTIVE_START_DATE), EMPLOYEE_NUMBER) = EFFECTIVE_START_DATE, 1,null()),</P><P style="font-size: 13.3333px;">However, all records return a null.&nbsp; I'm not sure that my set expression in the MAX function is correct.&nbsp; Any assistance would be appreciated.</P></BODY></HTML> Thu, 14 Jan 2016 19:37:30 GMT https://community.qlik.com/t5/QlikView/Display-most-recent-record-before-a-date/m-p/1092747#M466784 2016-01-14T19:37:30Z Re: Display most recent record before a date https://community.qlik.com/t5/QlikView/Display-most-recent-record-before-a-date/m-p/1092748#M466785 <HTML><HEAD></HEAD><BODY><P>Would you be able to share some sample data points with your desired output?</P></BODY></HTML> Thu, 14 Jan 2016 20:04:55 GMT https://community.qlik.com/t5/QlikView/Display-most-recent-record-before-a-date/m-p/1092748#M466785 sunny_talwar 2016-01-14T20:04:55Z