max date

[master_student]

Hello

It is me again

My sql query returns 3 rows for the same id, see bellow :

I would like to keep only one row (max valid from date) ; the first row

any function in Qlik

Thanks

[Chanty4u]

try

=Firstsortedvalue(Field,-Date)

[sasikanth]

Try this,

Firstsortedvalue(ID,-Aggr(max(Date),ID))

[Chanty4u]

or FirstSortedValue( ID, -aggr(Max(Date)) )

[pipuindia99]

max(timestamp(date)) or use firstsortedvalue function

[sdmech81]

Hi either this:

=Firstsortedvalue(ID,-Aggr(max(Date),ID))

or u can use firstvalue() function aswell bcs ur data looks already aggregated based on date.

Sachin

[master_student]

The field ID in my case : imei_number

Firstsortedvalue(mei_number,-Aggr(max(valid_from),mei_number)) ?