Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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