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

RangeSum last week

Any way that Range Sum can be used to sum up the previous Calendar weeks sales?  I have an expression, but it does not provide the desired data.

Expression I have:

RangeSum(Distinct{$<[completed_date.autoCalendar.Date]={">=num(today())-7<=num(today())"}>}(order_total), (order_id))

Maybe using week, weekstart, or weekend functions, but not sure.  Any help?  Thanks in advance.

1 Reply
tresesco
MVP
MVP

Have you tried with Sum() instead? like:

Sum(Distinct{$<[completed_date.autoCalendar.Date]={">=num(today())-60<=num(today())"}>} order_total)