Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasdavis500
Creator III
Creator III

Returning Dimension Value that AGGR() Aggregated over

I'm trying to return the dimension value that AGGR() has created and aggregated over. I've used the following formula in an expression, with Month as my dimension in my chart, to find the max values every month:

=MAX(AGGR(SUM({<[Not_My_Dummy] = {'0'} , My_dummy = {'1'}, ResolutionDate -= {'Null'}>} ABC_Resolved_Dummy), ResolvedBy, Month))

aggr.png

However, I would like to return the Dimension Values that correspond to these numbers, is this possible? For example, in August, the Max count is 232, corresponding to John Doe. I wish to represent John Doe on this chart for August so it's easy to I.D. who is performing well...

0 Replies