topic Re: 12 Month Rolling Average Query in QlikView

12 Month Rolling Average Query

Thu, 06 Aug 2015 03:27:36 GMT

Hello Everyone,

I am trying to do a 12 month rolling average with the chart below.

See below Expression I used to generate above chart. How do I do a 12 months rolling AVG for above chart please?

Thanks tons in advance!!

Re: 12 Month Rolling Average Query

sunny_talwar — Thu, 06 Aug 2015 03:34:31 GMT

Try this may be:

RangeAvg(Above(Sum([Total BBLs])/1000000, 0, 12))

Re: 12 Month Rolling Average Query

Thu, 06 Aug 2015 03:44:07 GMT

The chart splits into different products(Dubai, Oman etc) when I added that Expression. So does not work

Re: 12 Month Rolling Average Query

sunny_talwar — Thu, 06 Aug 2015 03:45:56 GMT

If you want it to be 12 Month Average of all products together, you might need this:

=RangeAvg(Above(Aggr(Sum([Total BBLs])/1000000, Trade_Month_Year), 0, 12))

Re: 12 Month Rolling Average Query

Thu, 06 Aug 2015 03:56:52 GMT

Got below chart, chart still splitting the products.

Re: 12 Month Rolling Average Query

Thu, 06 Aug 2015 07:17:33 GMT

It is possible that I need to change my the other Expression so that my bar charts will not split? see below

Re: 12 Month Rolling Average Query

jonathandienst — Thu, 06 Aug 2015 07:24:19 GMT

I don't think you can combine a stacked bar (stacked via dimension) with a line on a second expression. The line forces the second dimension onto the axis.