Max value for an object in specific context

[#1]

Hi Folks,

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.

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?

Can anyone help me with this please ?

Thanks in advance,

Glyn

[Clever_Anjos]

Maybe you should use AGGR

AGGR(max (Action date), [complaint ID]) will return a list for all max´s for each complaint ID

[#3]

Thanks for your quick response Clever Anjos, I'll try that and let you know if that solves my issue.