Discussion Board for collaboration on QlikView Layout & Visualizations.
I want to create a chart that uses accumulation (I assume in some way).
This is what I want the outcome to look like:
DATE Total Acc per month Acc per year
2012 jan-01 100 100 100
2012 jan-02 120 220 220
2012 jan-03 80 300 300
2012 jan-31 110 1300 1300
2012 feb-01 90 90 1390
2012 feb-02 130 220 1610
I.e. for each month I want the accumulation to start from scratch.
But I want to display the indivudual dates in the month
When experimenting with the accumulation settings in the expression I can not get it to start from scratch each month.
Instead it just accumulates the number of steps back that I set.
Is this possible?
Please see attached.
You need to create additional fields for Month (using Monthstart) and year, then you can create the expression for monthly accumulation like
=aggr( rangesum(above(Value,0, rowno())),Month,Date)
Hope this helps,
View solution in original post