topic Re: Week over Week calculation in App Development

Week over Week calculation

Anony — Mon, 29 May 2023 07:02:30 GMT

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)

Re: Week over Week calculation

BrunPierre — Mon, 29 May 2023 08:17:02 GMT

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

Re: Week over Week calculation

Anony — Mon, 29 May 2023 08:35:24 GMT

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.