Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasdavis500
Creator III
Creator III

Getting max value from a list with Aggr() function

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                    Luke                         1

Jan                    Jeff                           0
Jan                    Chris                         1

Feb                    Jeff                           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.

0 Replies