Getting max value from a list with Aggr() function

lucasdavis500 — Wed, 02 Nov 2016 15:03:14 GMT

I'm trying to pull the max value from a list of and display this across a chart....

I have created a dummy variable, as well as have a dimension to calculate across.

here's the formula I'm using:

=MAX(AGGR(SUM({<[Some_Var1] = {'0'} , Some_Var2= {'1'}>} My_Dummy), ResolvedBy))

I also use a Month dimension in the chart that this expression lies, because I want the max value by month...

Here's sample data:

Month ResolvedBy My_Dummy

Jan Luke 1

Jan Jeff 0
Jan Chris 1

Feb Jeff 1

Feb Chris 1

So, my chart would have Jan below my bar, the value of the bar would be TWO (2), and the person with the highest SUM would be Luke. For Feb it would be Jeff, again with TWO (2).

The formula above doesn't return the appropriate values, and I'm not sure how to return an appropriate Dimension Value that is acquired using the AGGR() function.

topic Getting max value from a list with Aggr() function in QlikView

Getting max value from a list with Aggr() function