Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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