topic Re: Get the most recent date in QlikView

None

Thu, 31 Oct 2013 13:23:03 GMT

None

Nicole-Smith — Thu, 31 Oct 2013 13:31:58 GMT

In the script, you can do:

INNER JOIN (YourTable)

LOAD Name,

max(B) as B

RESIDENT YourTable

GROUP BY Name;

israrkhan — Thu, 31 Oct 2013 13:41:09 GMT

fins the attached...

Thu, 31 Oct 2013 13:50:14 GMT

Is it possible to do for third column instead of max(date(B))

I want to show corresponding Date according to the maximum of Date (A) so for example

id, a , b

a, 1/1/2012, 2/1/2013

a, 5/1/2012, 1/1/2010

then a should be

a, 5/1/2012, 1/1/2010

Currently it's just maximum ?

Thanks btw

Gysbert_Wassenaar — Thu, 31 Oct 2013 14:27:13 GMT

Use firstsortedvalue(b,-a) to get the value of b for the maximum value of a

Thu, 31 Oct 2013 16:20:41 GMT

It doesn't work !

If I don't select particular name, it gives me the correct A value out of all name, but when I do select a name, it fails !