Aggr / Set Analysis Problem

[matancha]

Hi All.

Please look at the atached qvw.

I want to take the UnitPrice  of the highest Ord, group by Key.

i.e: to the Key = pal-320346 I want to show: 34.2

Key = pal-323111 I want to shoe: 11.2

My expression is:  Sum ({< Ord = {'=(Aggr(Max(Ord),Key))'} >}(UnitPrice) )

The QV take the UnitPrice from the first loaded row.

How can i do that?

Many Thanks -
Matan.

[matancha · Accepted solution]

Ok...

Think that found solution.

Expression:

Sum ({< Ord = {'= Ord =(Aggr(NODISTINCT Max(Ord),Key))'} >}(UnitPrice) )

See attached -

Matan.

[#3]

Hi

A simplier way to do this create an expression

=FirstSortedValue( UnitPrice , -Ord)

(if Ord > 0)

JJ