Qlik Sense - Filter in Measure expression

[mvgadagi]

Hello Team,

Currently, I have a table as below and I need to put filter in the expression in Qlik Sense

Can you please help to write a filter expression to get the only one record which is not in Done status and having least date,

From my below table I wanted to get the Name as Record 2 as the status is not Done and the date is smallest of the records which are not in done status

ID	Name	Date	Status
1	Record 1	2019-10-08	WIP
2	Record 2	2019-09-18	ASSIGNED
3	Record 3	2019-08-15	DONE

[asinha1991]

maybe this

firstsortedvalue(aggr(only({<STATUS-={'DONE'}>}NAME),NAME), DATE)

[naumanshah]

=Min(if(Status<>'DONE',Date))

Hope it helps!

[JGMDataAnalysis]

Only({<[ID] = {$(=FirstSortedValue({<[Status] -= {DONE}>} Distinct [ID], [Date]))}>} [Name])