Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSenseUser2
Contributor III
Contributor III

Most recent date

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

QlikSenseUser2_0-1626041121737.png

 

 

 

1 Solution

Accepted Solutions
QlikSenseUser2
Contributor III
Contributor III
Author

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

View solution in original post

6 Replies
Don_Stocks_
Contributor III
Contributor III

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

Don Stocks
QlikSenseUser2
Contributor III
Contributor III
Author

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

QlikSenseUser2_0-1626035840718.png

QlikSenseUser2_2-1626036005241.png

 

 

QlikSenseUser2
Contributor III
Contributor III
Author

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

QlikSenseUser2_0-1626041042838.png

 

Vegar
MVP
MVP

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))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
QlikSenseUser2
Contributor III
Contributor III
Author

I have these columns

QlikSenseUser2_0-1626043698550.png

 

QlikSenseUser2
Contributor III
Contributor III
Author

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

View solution in original post