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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get records with highest dates

Hi,

I have situation where I must extract records with highest starting date if they are more than one SifDat values..

Was tried with FirstSortedValue, but I always get blank records..

Any idea and thanks in advance,

Igor

1 Solution

Accepted Solutions
sasikanth
Master
Master

Try below expression in chart

=FirstSortedValue(  [Starting Date],- aggr( max([Starting Date]),SifDat,SifraCen))

View solution in original post

4 Replies
Not applicable
Author

could u pls share some sample data

Not applicable
Author

sample data is in attached qwv, Thx

sasikanth
Master
Master

Try below expression in chart

=FirstSortedValue(  [Starting Date],- aggr( max([Starting Date]),SifDat,SifraCen))

Not applicable
Author

Thx a lot ..