Discussion Board for collaboration on QlikView Layout & Visualizations.
I'm doing a chart with the accumulation 12 functionality.
My problem with the chart, I would like to show only the results after the initial 12 month accumulation.
In Qlikview I didnt find a way to make the chart start after the 12 months without selecting the data.
Please see below my chart in qlikview
and the idea is to have the following functionaly (I have did this in excel as example)
Please find enclosed the example data report
I appreciate your support!
Thanks in advance, Leandro
Go to Solution.
Create a Line Chart
Add Calculated Dimension
=IF(Month > 12, Month)
Tick Suppress When Value is Null
Expression (REF: Henric)
Hope this helps...
This is not possible using this type of accumulation. The accumulation is made on the possible data; and the graph shows the possible months: Then that is what the curve looks like.
What you can do instead is the following:
Then you can select the months you want to see, and the expression will calculate a 12-month accumulation also outside the scope of the selection.
See more on:Calculating rolling n-period totals, averages or other aggregations