topic Using Aggr(...), expressions, and max in QlikView

Using Aggr(...), expressions, and max

Wed, 23 May 2012 14:58:45 GMT

Hello, I am trying to use Aggr(....) and I'm having problems. This is how I understand it works.

Max(
  { < Date = {"=Aggr(Date, @5)"} > }
   @5
 )

This code will make a table out of Date and @5 and find the max value of @5. The thing is, I need @5 to be an expression. How can I extract the max of the second column in my table created by Aggr? It doesn't seem to work with just the expression in the place of all the @5's, should that work?

Using Aggr(...), expressions, and max

Jason_Michaelides — Wed, 23 May 2012 15:25:16 GMT

Erm...I don't inderstand! What do you want your finished chart to show, exactly? Please give an example expression.

Using Aggr(...), expressions, and max

Wed, 23 May 2012 15:26:42 GMT

It's just for a variable. So I just need the one value.

Using Aggr(...), expressions, and max

Jason_Michaelides — Wed, 23 May 2012 15:30:36 GMT

Help me out here...please provide some specific examples and if possible some sample data. Makes helping you a lot easier...