Comparing Weeks Across Years

cluscombe — Tue, 21 Apr 2020 17:08:57 GMT

Hi Qlik Community -

I am working on a project to compare metrics at a weekly level across multiple years. We are in a business that has a predicable rhythm throughout the week, so its very important I am comparing similar 7 day periods. The problem I am running into is that week 14 of the current year has a different date range of week 14 of the prior year. Example:

week 14 of current year could be Monday - Sunday
week 14 of prior year could be Tuesday - Monday

So comparing week 14 from current year and prior year is not comparing similar periods and I could easily draw incorrect conclusions.

How do I control for this to ensure I am comparing similar 7 days period across years? I assume its something in the master calendar but other than that I am lost.

topic Comparing Weeks Across Years in App Development

Comparing Weeks Across Years