Qlik Sense | Calculating Moving Average Trend line

Hi

try like below, For example,

let's take 7 Days Rolling Average then u have to write like this

rangeavg(above(sum(sales),0,7))

also check this thread,

moving average in qlikview | Qlik Community

Thanks,
Deva

Hi,

Refer to the attached sample,

Fact:
load * Inline [
date,sales
20/5/2012, 10
21/5/2012, 15
22/5/2012, 16
23/5/2012, 9
24/5/2012, 15
25/5/2012, 12
26/5/2012, 20
27/5/2012, 15
28/5/2012, 10
29/5/2012, 14]