Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
maybe this
firstsortedvalue(aggr(only({<STATUS-={'DONE'}>}NAME),NAME), DATE)
=Min(if(Status<>'DONE',Date))
Hope it helps!
Only({<[ID] = {$(=FirstSortedValue({<[Status] -= {DONE}>} Distinct [ID], [Date]))}>} [Name])