Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Folks,
Anyone figure out how to generate a moving average trend line in Qlik Sense yet? or via an extension?
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]
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.