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

Aggr / Set Analysis Problem

Matan Chalamish Oct 2, 2011 3:32 AM

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.

Re: Aggr / Set Analysis Problem

Matan Chalamish Oct 2, 2011 4:38 AM (in response to Matan Chalamish)
Ok...
Think that found solution.

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

See attached -
Matan.

OrdSol.qvw 152.8 K
Like Show 0 Likes (0)

Actions
- Aggr / Set Analysis Problem
  
  Jean-Jacques Jesua Oct 2, 2011 1:23 PM (in response to Matan Chalamish)
  
  Hi
  
  A simplier way to do this create an expression
  
  =FirstSortedValue( UnitPrice , -Ord)
  
  (if Ord > 0)
  
  JJ
  
  Like Show 0 Likes (0)
  
  Actions