Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

12 Month Rolling Average Query

Hello Everyone,

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

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

Rolling AverageIssue3.jpg

Thanks tons in advance!!

6 Replies
sunny_talwar

Try this may be:

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

Not applicable
Author

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

sunny_talwar

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))

Not applicable
Author

Got below chart, chart still splitting the products.

Rolling AverageIssue5.jpg

Not applicable
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein