Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DakshP
Contributor
Contributor

Search Max Date present in a field corresponding to a particular id number

The table format is -

Date | Id | Other data

22/03/22 | 391 | other data 1

21/04/22 | 391 | other data 2

22/03/22 |310| other data 3

19/05/22 | 310 | other data 4

10/02/22 |310| other data 5

.

.

.

I want to add a column in vizlib chart that would give me 'other data' based on a given id number and max date corresponding to that id number. 

i.e for id =391, I should be getting 'other data 2' as a result since the maximum date corresponding to this id is 21/04/22.

for id = 310, I should be getting 'other data 4' as a result since the maximum date corresponding to this id is 19/05/22.

2 Replies
Chanty4u
MVP
MVP

try this

FirstSortedValue(Id, -Date)

DakshP
Contributor
Contributor
Author

@Chanty4u Can you please provide the complete expression? 

P.s. I need "Other Data" on the basis of Id and max date corresponding to that id.