Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New 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 (3)
3 Replies
Highlighted
Contributor III

Re: Qlik Sense - Filter in Measure expression

maybe this

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

 

Highlighted
New Contributor III

Re: Qlik Sense - Filter in Measure expression

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

Hope it helps!

Highlighted
Contributor II

Re: Qlik Sense - Filter in Measure expression

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

clipboard_image_1.png