Discussion Board for collaboration on QlikView Layout & Visualizations.
How can I sum up the previous months of the current year?
Examples: sum all of January to April
Jan = 10
20 = Feb
Mar = 10
Apr 5 =
I got back 45
How could I do this?
If this option is selected, each y-value will accumulate all previous y-values of the expression. See above under Accumulation.
Accumulate n Steps Back
By entering a number in the box, you set the number of y-values in the expression to be accumulated. See above under Accumulation
Bar Chart-->Expression-->Full Accumulation
i hope it should help