Select the last X Date

[#1]

I want click view to choose the previous months but don't know how to tell it.  For example, Today is June 15th, I want qlikview to give me the previous 5 months.  When the date is July 18th, I want it to give me the previous 6 months, etc.

Any help is appreciated.

[#2]

try this

sum({<Date = {">=$(=MonthStart(Max(Date), -5))<=$(=MonthEnd(Max(Date)))"},DATE=,Year=,Month=>}Sale)

[er_mohit]

see the attached file

hope it helps you