Week over Week calculation

[Anony]

Hi All,

I have a requirement in qlik sense to filter the metrics for last 5 weeks. For eg if user has selected any date from date filter then 5 different charts should  show data for previous 5 weeks(week1, week 2,...Week5)

[BrunPierre]

Sum({<Date={">=$(=Week(max(Date))-4)<=$(=Week(max(Date)))"}>}Sales)

[Anony]

Hi @BrunPierre Thank you for your response. Expected output is to show sum of sales separately for last 5 weeks like week 1 sales, week2 sales...week5 sales.