Qlik Sense | Calculating Moving Average Trend line

[dltsonope]

Folks,

Anyone figure out how to generate a moving average trend line in Qlik Sense yet? or via an extension?

[devarasu07]

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

[devarasu07]

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]

[dltsonope]

Thanks for the post, the challenge which remains is I have a multi-series trend line of which I wish to add a moving average trend line.