topic Max in a month in QlikView

Max in a month

qlikviewaf — Mon, 10 Sep 2018 14:16:57 GMT

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 — Mon, 10 Sep 2018 14:39:06 GMT

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

qlikviewaf — Mon, 10 Sep 2018 15:12:55 GMT

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?