Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Week vs. Week

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

2 Replies
el_aprendiz111
Specialist
Specialist

Hi,

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

shraddha_g
Partner - Master III
Partner - Master III

try

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