Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

morning guys, i am new to qlikview so i have a created a pivot table report so i am strugling with the accumulation on it. anyone that can help please?

accumulation on pivot table report. below is the screen shot of the report:

3 Replies
Anonymous
Not applicable
Author

Hi Judas,

I did not understand where is the problem.

Could you be more specific in your request ?

Maybe I can help you

Not applicable
Author

Hi Francesco,

I have below screenshots pivot table report so what I am looking for is the accumulation on values,eg

31-mar-14 value =(8) to be added with 30-apr-14 value(10) to populate 18 for 30-apr-14 and for 31-may-14 to populate 18 + 1 which value for may to make it 19 and for 30-jun-14 populate previous value(19)+2 for jun to make it 21, same for july, aug sep oct, nov ,dec, jan-15, feb-15, mar-15 and so on.

the same principle to be applied on the percentage pivot as well.

Anonymous
Not applicable
Author

Hi judas,

try with this expression before(sum(NumericField))