Help with Set Analysis

[ramanarayan]

I am trying to calculate the sum of Amt using a set analysis expression but not been successful

I need qlikview to give me the total sales amount for the max of month. 

In my attached qv file, the max month is Sept and the amount is 7. I am using the following expression but it does not seem to work.

=sum({<Mon = {"max (mon)"}>}Amt)

[agigliotti]

let's try this:
=sum( {<Mon = {"$(=Max(mon))"}>} Amt )
I hope it helps.

[ramanarayan]

Hi,

I tried using this expression but the output is 0 and not 7. Attached is the qvw file

[agigliotti]

try this:
sum( {< Mon = {"=Month(Mon) =month(date(max( total Mon)))"}>} Amt)

[marcus_malinow]

sum({$<Mon={'$(=Date(max(Mon)))'}>}Amt)