Max in a month

[qlikviewaf]

Hi,

my data set is as follow:

1/1/2018 - 100

2/1/2018 - 130

3/1/2018 - 140

there's a way to get the value related to the higher date for a month?

For example, in January i would like to see 140, which is the highest date value.

Which is the right formula to be used?

here is the graph i would like to use

Thank you!

[Anonymous]

try "aggr(max(yourvalue), monthfield)"

[qlikviewaf]

I was able to find the max date that i have to consider (Field Data Max by Month), but how to get the related value?

i want for 19/09/2011 to have just 23 and for 29/10/2011 just 232

how i can do it?