max and corresponding value

[amien]

MAX(TOTAL <key> date)

i have this expression and gives me a date as result. the date is linked to a caseid.

how do i get the corresponding caseid, based on the MAX(TOTAL <key> date) expression?

[amien]

/bump

[Anonymous]

Try set analysis expression, something like this:

=only({$<date= {$(=max(total<key> date))}>} caseid)

[amien]

not really working .. i have added a sample qv including your expression.

anyone knows whats wrong?

[amien]

/bump

[#6]

Hi,

try only(if(date=aggr(nodistinct max(date),key),case_id2))

Alex

[amien]

Thanks .. works . .only problem is that if there are more then one cases where date = max(date), cell is empty .. so i changed only to max

[amien]

correction on last post:

why are you comparing date with max(date)?

isnt MAX(TOTAL <key> date) enough?

[#9]

I just applied this to an equivalent problem, and it worked fine.

Thanks!