Restrict date for last 3 dates

[priya945]

HI  All,

Could some one help me  how to use this  

Date={">=$(=addmonths(Max(TempDate), -2)) <=$(=Max(TempDate))"} to restrict the data for last 3 dates in below expression

expression: 1-(sum({<Flag={Close}>}[exp1])/count({< Flag={Close}>} distinct [exp2]))

Thanks In advance

[alex00321]

Hi your formula works, I just use attached file for your reference. The first table called Normal is all data view, and another is just latest 3 months in the date field. Thanks!

[Brett_Bleess]

The only additional thing I can add to the thread is a Design Blog post that may be of some help:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Regards,
Brett