Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
manishapanda1
Contributor III
Contributor III

Accumulation

can any one Please help me to understand what is Accumulation, No Accumulation and full Accumulation? and when we need this with a scenario.

6 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Manisha,

Please refer below thread you will get idea,

Accumulation in Qlik Sense | Qlik Community

Thanks,

Arvind Patil

manishapanda1
Contributor III
Contributor III
Author

Hi Arvind,

Thanks for your response, but that discussion is not clearing my doubts, want to know the difference and use of No Accumulation, Full and Simple Accumulation in Qlickview. is it possible to describe in Brief.

Thanks,

MP

trdandamudi
Master II
Master II

See if the below links will help to understand:

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

Full Accumulation example

What is No Accumulation and full accumulation w... | Qlik Community

Accumulation in qlikview

Hope this helps...

Anonymous
Not applicable

trdandamudi
Master II
Master II

If you think you got the answer, can you please close the thread so that it will be useful for other users.

manoranjan_d
Specialist
Specialist

Hello Manish Punda

pls refer this video link and spend 10 mins to see the video to get clear understanding of your query

QlikView Tutorials | Expressions | Creating Running Total or Rolling n days total - YouTube