how to filter the date

[qlick_qa1]

Hi, for a new line chart, i connected a database that has date dimention and  it is refreshing daily.  It covers past years till the day before. I want the line chart to show just the last 28 days. How can i filter the last 28 days ?   

[sidhiq91]

@qlick_qa1  Please use the below expression in the measure.

Sum({<Date={">=$(=Date(Max(Date)-28,'MM/DD/YYYY'))<$(=Max(Date))"}>}Sales)

If this resolves your issue please like and accept it as a solution.