Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dltsonope
New Contributor II

Qlik Sense | Calculating Moving Average Trend line

Folks,

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

3 Replies
devarasu07
Honored Contributor II

Re: 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

devarasu07
Honored Contributor II

Re: Qlik Sense | Calculating Moving Average Trend line

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]

Capture.JPG

dltsonope
New Contributor II

Re: Qlik Sense | Calculating Moving Average Trend line

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.

Community Browser