2 Replies Latest reply: Oct 2, 2011 1:23 PM by Jean-Jacques Jesua RSS

    Aggr / Set Analysis Problem

    Matan Chalamish

      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 -