topic max and corresponding value in QlikView

max and corresponding value

amien — Fri, 25 Jun 2010 09:55:11 GMT

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 — Wed, 30 Jun 2010 13:44:08 GMT

/bump

Anonymous — Wed, 30 Jun 2010 14:51:19 GMT

Try set analysis expression, something like this:

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

amien — Sat, 03 Jul 2010 20:28:54 GMT

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

anyone knows whats wrong?

amien — Mon, 05 Jul 2010 12:41:45 GMT

/bump

Mon, 05 Jul 2010 13:17:03 GMT

Hi,

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

Alex

amien — Mon, 05 Jul 2010 14:02:25 GMT

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 — Fri, 09 Jul 2010 14:51:37 GMT

correction on last post:

why are you comparing date with max(date)?

isnt MAX(TOTAL <key> date) enough?

Sat, 11 Sep 2010 03:01:57 GMT

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

Thanks!