topic Re: Rolling Average Issue in QlikView

Rolling Average Issue

Wed, 05 Aug 2015 09:31:26 GMT

Hi Everyone,

Need advise with Rolling Monthly Average. Please see below how I tried but failed.

Re: Rolling Average Issue

sunny_talwar — Wed, 05 Aug 2015 09:35:04 GMT

As far as I know, reference lines are straight lines and cannot move up or down. Why don't you use a combo chart and add another expression (RangeAvg(Above(Sum([Total BBLs]), 0, 12))/1000000) for your reference line.

Re: Rolling Average Issue

Wed, 05 Aug 2015 09:43:30 GMT

The problem is the Dimension has Product(which is broken down into several sub-products). See below

I don't want the Average for each Sub-products, but the moving average of the main products, and the same time displaying the sub-products in each bar.

Re: Rolling Average Issue

sunny_talwar — Wed, 05 Aug 2015 09:48:45 GMT

Maybe use TOTAL in your expression:

RangeAvg(Above(Sum(TOTAL <Sub-Poducts> [Total BBLs]), 0, 12))/1000000

Re: Rolling Average Issue

Wed, 05 Aug 2015 09:56:41 GMT

Hmm, doesn't work.

Re: Rolling Average Issue

sunny_talwar — Wed, 05 Aug 2015 09:59:04 GMT

Not sure if this will work or not, but can you try this as well?

RangeAvg(Above(Sum(TOTAL <Product> [Total BBLs]), 0, 12))/1000000

Re: Rolling Average Issue

Wed, 05 Aug 2015 10:01:31 GMT

See below, I am trying to put a Rolling Average for the below chart