Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to calculate Cumulative Sum

Hi,

How can I calculate the cumulative sum. Please see attached

Tags (1)
1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: How to calculate Cumulative Sum

hei

attach is an example

look at the load script the calculation of the accumuleted sales is there

3 Replies
lironbaram
Honored Contributor II

Re: How to calculate Cumulative Sum

hei

attach is an example

look at the load script the calculation of the accumuleted sales is there

How to calculate Cumulative Sum

Hi,

Yes you can achieve this by Subtract the fields by Target - salevolume and get another field as Target_Left and put this below the all fields and you get the subtract value.

Regards,

Anand

Not applicable

How to calculate Cumulative Sum

Thanks liron baram

Community Browser