topic Re: Accumulation in QlikView

Accumulation

manishapanda1 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Accumulation

arvind_patil — Tue, 11 Sep 2018 10:43:54 GMT

Hi Manisha,

Please refer below thread you will get idea,

Accumulation in Qlik Sense | Qlik Community

Thanks,

Arvind Patil

Re: Accumulation

manishapanda1 — Tue, 11 Sep 2018 11:05:21 GMT

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,

Re: Accumulation

trdandamudi — Tue, 11 Sep 2018 11:25:30 GMT

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...

Re: Accumulation

Anonymous — Tue, 11 Sep 2018 11:37:08 GMT

Kindly refer the below for your query.

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

Re: Accumulation

trdandamudi — Tue, 11 Sep 2018 11:43:55 GMT

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

Re: Accumulation

manoranjan_d — Tue, 11 Sep 2018 11:58:10 GMT

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