max of date returning associated value

[qliklizzy]

hi

i am stuck on this piece of code

=max({<MetricDesc=,MetricID={'LI01'}, StatusExclude={'No'},Location-={'EAU'},EDready={'Y'}>} EDreadyTime)

this gives me the maximum datetime entered, but i want it to return the associated waittime.  this field= PreEDReadyWait)/24/60, 'hh:mm')

how to i achieve this?

thanks for your help

[qliklizzy]

i will try again...

[qliklizzy]

and the text that followed:

i have just made a table to show you this; but also noticed i am missing those who have no location - so i need to factor these in also.

basically I want to show the Pre ed ready wait for the latest patient on there who is ED ready:  so the result should be: this person at  06/10/16 15:55 and i need to bring back their wait which is 220 minutes (in hours and mins)

hope this makes sense, thanks for looking