topic Aggr / Set Analysis Problem in QlikView

Aggr / Set Analysis Problem

matancha — Sun, 02 Oct 2011 07:32:06 GMT

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 — Sun, 02 Oct 2011 08:38:59 GMT

Ok...

Think that found solution.

Expression:

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

See attached -

Matan.

Sun, 02 Oct 2011 17:23:25 GMT

A simplier way to do this create an expression

=FirstSortedValue( UnitPrice , -Ord)

(if Ord > 0)