Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
RimDataAnalyst
Contributor III
Contributor III

get the last date from a table

Good morning ,
I have a table that contains ICAO , input date , achievement
I want for each ICAO to retrieve the last achievement that corresponds to the most recent date.
I want to get this last achievement for each ICAO, I tried the max ( input date ) and FirstSortedValue([Input Date], ICAO) the first one does not give what I want since in the group by I have to put ICAO and achievement and the second generation generates an error

Labels (2)
6 Replies
BrunPierre
Partner - Master II
Partner - Master II

Hi, as below.

Dimension: ICAO 

Expression: FirstSortedValue(achievement,-[input date])

RimDataAnalyst
Contributor III
Contributor III
Author

i tried this in the chart and it doesn't work 

BrunPierre
Partner - Master II
Partner - Master II

Share sample data and your expected results.

RimDataAnalyst
Contributor III
Contributor III
Author

i want only the to get the achievement of 05-Jan-23 

BrunPierre
Partner - Master II
Partner - Master II

Aggr(Max([input date]), ICAO)

vinieme12
Champion III
Champion III

as below

 

=max ( TOTAL <ICAO> input date )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.