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: 
mvgadagi
Contributor III
Contributor III

Qlik Sense - Filter in Measure expression

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

IDNameDateStatus
1Record 12019-10-08WIP
2Record 22019-09-18ASSIGNED
3Record 32019-08-15DONE
Labels (2)
3 Replies
asinha1991
Creator III
Creator III

maybe this

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

 

naumanshah
Contributor III
Contributor III

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

Hope it helps!

JGMDataAnalysis
Creator III
Creator III

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

clipboard_image_1.png