Most recent date

[QlikSenseUser2]

How can I show just the most recent dates for TRAILER?

[Don_Stocks_]

AddYears(max(total <TR> [Last Day]),1)

[QlikSenseUser2]

I want to make sure I'm doing this right. I tried this and it didn't go through. Is this correct?

[QlikSenseUser2]

How can I show just the most recent dates for TRAILER?

[Vegar]

Is TRAILER and LAST_INSPECTION_DATE the only columns in your table? Then you could try to keep TRAILER as a dimension,  but remover the LAST_INSPECTION_DATE in favour of a new measure column with this expression:

Dayname(Max(LAST_INSPECTION_DATE))

[QlikSenseUser2]

I have these columns

[QlikSenseUser2 · Accepted solution]

Thanks. Had to use Aggr(max(LAST_INSPECTION_DATE),TRAILER).