This content has been marked as final.
Show 3 replies
-
Re: Qlik Sense | Calculating Moving Average Trend line
Devarasu R Dec 8, 2017 1:30 AM (in response to Dikitso Tsonope )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 -
Re: Qlik Sense | Calculating Moving Average Trend line
Devarasu R Dec 8, 2017 1:36 AM (in response to Dikitso Tsonope )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]
-
Rolling Av.qvf 192.0 K
-
Re: Qlik Sense | Calculating Moving Average Trend line
Dikitso Tsonope Dec 8, 2017 2:19 AM (in response to Devarasu R)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.
-