topic Re: Max value for an object in specific context in QlikView https://community.qlik.com/t5/QlikView/Max-value-for-an-object-in-specific-context/m-p/995837#M967330 <HTML><HEAD></HEAD><BODY><P>Thanks for your quick response Clever Anjos, I'll try that and let you know if that solves my issue.</P></BODY></HTML> Mon, 05 Oct 2015 14:38:41 GMT 2015-10-05T14:38:41Z Max value for an object in specific context https://community.qlik.com/t5/QlikView/Max-value-for-an-object-in-specific-context/m-p/995835#M967328 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I am fairly new to QlikView and I am having difficulty trying to get the max value of an item but I only want it within a certain context.</P><P>i.e. I need the max (Action date) per complaint ID for the App I am creating. But was not sure how to create an expression for this?</P><P> Can anyone help me with this please ?</P><P>Thanks in advance,</P><P></P><P>Glyn</P></BODY></HTML> Mon, 05 Oct 2015 11:28:31 GMT https://community.qlik.com/t5/QlikView/Max-value-for-an-object-in-specific-context/m-p/995835#M967328 2015-10-05T11:28:31Z Re: Max value for an object in specific context https://community.qlik.com/t5/QlikView/Max-value-for-an-object-in-specific-context/m-p/995836#M967329 <HTML><HEAD></HEAD><BODY><P>Maybe you should use AGGR</P><P></P><P>AGGR(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">max (Action date), [<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">complaint ID]) will return a list for all max´s for each <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">complaint ID</SPAN></SPAN></SPAN></P></BODY></HTML> Mon, 05 Oct 2015 12:52:02 GMT https://community.qlik.com/t5/QlikView/Max-value-for-an-object-in-specific-context/m-p/995836#M967329 Clever_Anjos 2015-10-05T12:52:02Z Re: Max value for an object in specific context https://community.qlik.com/t5/QlikView/Max-value-for-an-object-in-specific-context/m-p/995837#M967330 <HTML><HEAD></HEAD><BODY><P>Thanks for your quick response Clever Anjos, I'll try that and let you know if that solves my issue.</P></BODY></HTML> Mon, 05 Oct 2015 14:38:41 GMT https://community.qlik.com/t5/QlikView/Max-value-for-an-object-in-specific-context/m-p/995837#M967330 2015-10-05T14:38:41Z