Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

rolling for 5 days?


date,amount

1/1/2014,100

2/1/2014,200

4/1/2014,300

5/1/2014,400

6/1/2014,500

7/1/2014,

8/1/2014,700

9/1/2014,

10/1/2014,900

11/1/2014,1000

12/1/2014,

13/1/2014,1200

14/1/2014,1300

15/1/2014,1400

here i want calculate for rolling 5 days avg for sum(amount)  ?

how to calculate it?

11 Replies
Anonymous
Not applicable
Author

if i take out the 0 what will happen is it effect on result

SunilChauhan
Champion II
Champion II

no,not at all

Sunil Chauhan