Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ShaoChi
Contributor III
Contributor III

how to calculate moving sum in the table

If I have data like this:

ShoppingDate consumer item
1/1 A 1
1/3 A 2
1/5 A 1
1/15 A 2
1/20 A 5
1/2 B 4
1/3 B 1
1/10 B 2
1/11 B 1

 

I want to calculate the sum of purchases made by each consumer in 3 days, like this

ShoppingDate consumer moving sum
1/1 A 1
1/2 B 4
1/3 A 3
1/3 B 5
1/5 A 3
1/10 B 2
1/11 B 3
1/15 A 2
1/20 A 5

 

How to use "Chart General Numeric Functions" to get the field "moving sum" value ??

Labels (2)
11 Replies
ShaoChi
Contributor III
Contributor III
Author

Sorry about that data reply, It's my mistake. I misunderstood is provided by me.
Your reply helped me a lot, thank you.

edwin
Master II
Master II

yw