Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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