Discussion Board for collaboration on QlikView Layout & Visualizations.
I have to create a derived field, which is a progressive on the month, accumulated up to the current month.
Example: Jan -> 1000, Feb -> 200; Mar -> 400; Apr -> 650.
The sequence should be: Jan -> 1000, Feb -> 1200; Mar -> 1600, April -> 2250.
I attach a screen. The field "(progressivo mese)" is what I get.
In a straight table chart use the following settings:
Expression: Sum(Value) and select Full Accumulation in the Accumulation window
This will generate table with cumulative values.
Thanks a lot.
But i have another question, because the problem is solved only in part.
When i select a month, example Giu, i lost the information accumulated, because the system result only value linked with Giu and not the values linked to Mag+Giu.
Is it possible to resolve this problem?
I load an image that explain this concept.
rangesum(valore,peek('valore',-1)) as valorecum;
LOAD * INLINE [