Discussion Board for collaboration related to QlikView App Development.
I need to create bar chart.
Bar chart should display dimension values only for last 12 Months. And each bar should display rolling 6 months of data.
I will have 12 bars for last 12 months (Sep-2014 to Aug 2015). Now the Sep-14 bar should display the values of rolling 6 months.
So Sep-2014 bar will display the values (Apr-2014 to Sep-2014). Like wise each bar should display rolling 6 months value.
Hope it is clear
Before going into too deep, have you tried using "Accumulate" option in the expression tab? You can set it to 6 steps back.
This may help
See attached example and this document: Calculating rolling n-period totals, averages or other aggregations
Possibly, there are several threads here in the forum covering a front end solution, e.g.
You can use Sum() instead of FirstSortedValue(), and maybe limit the dimensions shown either by setting in the chart properties or by using set analysis in the outer aggregation.