topic Re: max date in QlikView

max date

master_student — Wed, 15 Feb 2017 10:22:06 GMT

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 — Wed, 15 Feb 2017 10:24:25 GMT

try

=Firstsortedvalue(Field,-Date)

sasikanth — Wed, 15 Feb 2017 10:27:11 GMT

Try this,

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

Chanty4u — Wed, 15 Feb 2017 10:30:59 GMT

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

pipuindia99 — Wed, 15 Feb 2017 10:33:17 GMT

max(timestamp(date)) or use firstsortedvalue function

sdmech81 — Wed, 15 Feb 2017 10:34:31 GMT

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 — Thu, 16 Feb 2017 15:47:33 GMT

The field ID in my case : imei_number

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