Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Highlighted
New Contributor III

Rolling 7 days

Hi Experts,

Would like to seek advise on how to write correct set analysis with this situation.

I have # Sales per day.

The results I want is the sum of the running 7 day sales

Sample Data                    

DateSales

Oct 1

5
Oct 210
Oct 38
Oct 49
Oct 57
Oct 65
Oct 76
Oct 84
Oct 92
Oct 1034
Oct 111
Oct 122
Oct 133
Oct 144
Oct 154
Oct 165

Desired Result

Date7 days sale
Oct 750 (sum of oct 1-7)
Oct 849 (oct 2-8)
Oct 941 (oct 3-9)
Oct 1067 (oct 4-10)
Oct 1159
Oct 1254
Oct 1352
Oct 1450
Oct 1550
Oct 1653
1 Solution

Accepted Solutions
Partner
Partner

Re: Rolling 7 days

Hi

small change  in Liron Baram exression.

rangesum(above(sum([Sales]),0,7))

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Rolling 7 days

hi

use this expression

rangesum(above(sum([Sales]),0,6))

Partner
Partner

Re: Rolling 7 days

Hi

small change  in Liron Baram exression.

rangesum(above(sum([Sales]),0,7))

View solution in original post