Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
phcaptjim
Creator
Creator

Another Rolling 12 Month Chart Question

I've been looking at the forums and reading various threads on setting up a chart that calculates on a rolling 12 month basis and I have two questions that I have not been able to figure out on my own.

I have attached a sample app and have two outstanding items I would like to complete:

  1. I need the calculation to work correctly when you click on one month.  Right now that is not working.  I've tried a few things but I can't seem to get this right.
  2. I only want the chart to show the last 10 months, but it should calculate the values for the full rolling 12 months.  When I use set analysis for this, I get 10 months displayed but the rolling 12 calculate properly.

Any ideas?  Thanks!

1 Reply
Gysbert_Wassenaar

If you want to show only ten months in the chart with rolling-12 month values then you can't use the simple rangesum(above(.. construction. You can use an AsOf table instead. See this document: Calculating rolling n-period totals, averages or other aggregations

See attached qvw.


talk is cheap, supply exceeds demand