Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jlampard40
Contributor III
Contributor III

Name of Month corresponding to the MAX value

Hi guys - I have some set analysis:

=max( aggr( count({<Activity_or_Demand={'Demand'}, Financial_Year_Week-={'2099-41'}, Room-={'CTSIM','CTSIM2'}>} Event_Key]), [Calendar_Year_Month]))

This shows me the MAX value within my data.  What I now need to show is the corresponding date (Calendar_Year_Month) that this applies to.  I have this data as a bar chart, spanning 5 years, so I am adding a text box next to it to show our users during which date (Calendar_Year_Month) the MAX value occurred in.

Thank you!

1 Reply
Marcos_Ferreira_dos_Santos

Hi Jlampard40

Have you found the solution for that need ? I hope so.

It seems a case for using the FIRSTSORTEDVALUE function, doesn't it?

Personally, I got to understand this in this worth reading article: https://www.analyticsvidhya.com/blog/2014/02/aggr/#:~:text=AGGR

Best regards,

Marcos