Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulation in qlikview

Hi Guys,

Can you please explain with an example for accumilation in expression tab(No accumulation,full accumulation,Accumulation) with step back)??

Regards,

sanjeev

1 Reply
Not applicable
Author

Hey Sanjeev,

1. No Accumulation is just your normal expression. The appropriate aggregated results(sum or count for example) against the respective dimensions

2. Full Accumulation is also called running total. It will take into consideration the current result + all the prior results. For example the result of fifth row(dimension) would be 1st+ 2nd + 3rd + 4th + 5th row results.

3.Step back is like a partial running total. Instead of taking all the previous records it only takes based on whats mentioned in the step back. Lets say step back is 3, then the result of the 5th record would be 3nd+4th+5th

Attached is an example.

Thanks