Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cscliffe10x
New Contributor II

Rolling Average in Column Chart

Hello,

I am trying to calculate a rolling average line where the 'average' for a month = (current month + previous month) / 2.

This is depicted by the 'average' row in the screenshot below.

For all intents and purposes, we will say that my expression is Sum(Sales).

Thank you.

Average.PNG

1 Solution

Accepted Solutions
mayuresh_d
Contributor

Re: Rolling Average in Column Chart

hi,

it will be better if you bring previous month sales against current month sales in script.

for that take resident of original table then in month field take it as (month-1)

and with help of key and month field join it to original table this will saves calculations on front end might increase front end calculation performance.

thanks

Mayuresh

7 Replies
MVP
MVP

Re: Rolling Average in Column Chart

May be this

RangeAvg(Before(Sum(Sales), 0, 2))

dan_sullivan
Contributor II

Re: Rolling Average in Column Chart

try something like this:

RangeSum(Sum(Sales),Above(Sum(Sales)))  / 2

cscliffe10x
New Contributor II

Re: Rolling Average in Column Chart

Close, but not quite

MVP
MVP

Re: Rolling Average in Column Chart

What is missing?

mayuresh_d
Contributor

Re: Rolling Average in Column Chart

hi,

it will be better if you bring previous month sales against current month sales in script.

for that take resident of original table then in month field take it as (month-1)

and with help of key and month field join it to original table this will saves calculations on front end might increase front end calculation performance.

thanks

Mayuresh

Highlighted
cscliffe10x
New Contributor II

Re: Rolling Average in Column Chart

Yes, this will work - thank you.

oknotsen
Honored Contributor III

Re: Rolling Average in Column Chart

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!
Community Browser