topic Re: Week vs. Week in QlikView

Week vs. Week

Anonymous — Fri, 27 Oct 2017 13:34:26 GMT

Hello,

Trying to compare week to date vs. previous week to date.

I have a text box set up which displays the sum of "Sales" for week to date but not sure how to add an additional text box which displays the previous week to dates performance performance.

Cheers

Chris

Re: Week vs. Week

el_aprendiz111 — Fri, 27 Oct 2017 19:23:29 GMT

Hi,

sum({<Week={$(=Max(Week)-1)}>}Sales)

Re: Week vs. Week

shraddha_g — Sat, 28 Oct 2017 03:31:48 GMT

try

sum({<DateField = {">=$(=Date(Max(WeekStart)-7))<=$(=Date(max(DateField)-7))"}>}Sales)