topic How to calculate accumulative value in QlikView

How to calculate accumulative value

vipingarg23 — Thu, 27 Sep 2018 14:16:59 GMT

HI Team,

Please find sample file as an attachment.

Here I have One field Month and One chart in which I am calculating Sum(Value) for ID.

My Requirement is that if user select Oct from month then SUm(Value) should be (Sep+Oct) and if user is selecting Dec then value should be (Sep+Oct+Nov+Dec) like this....

Can anyone help me on the same.?

Regards,

Vipin Garg

Re: How to calculate accumulative value

diego_vazquez — Thu, 27 Sep 2018 14:27:50 GMT

Hello,

you can try this expresion:

IF(Month = 'Sep', Sum({<Month={'Sep','Oct'}>}Value), IF(Month = 'Dec', Sum({<Month={'Sep','Oct','Nov','Dec'}>}Value), Sum(Value)))

Diego

Re: How to calculate accumulative value

vipingarg23 — Thu, 27 Sep 2018 14:27:50 GMT

Hi..Thanks for your reply but it is just sample data. I have lots of Month and Year. So I can't do manually for every selection.

Re: How to calculate accumulative value

vipingarg23 — Thu, 27 Sep 2018 14:32:46 GMT

I want like

If sep is selected then Only sep data

if Oct is selected, it will show sep+oct

if Nov is seleted, it will show sep+oct+nov

If dec then sep+oct+nov+dec

so on....

Re: How to calculate accumulative value

diego_vazquez — Thu, 27 Sep 2018 14:36:16 GMT

try to group the selections you need in a load inline in the script.

Re: How to calculate accumulative value

vipingarg23 — Thu, 27 Sep 2018 14:38:36 GMT

I am not taking data from inline. I have field like Sales Period which contains lots of Month Year Value

Re: How to calculate accumulative value

diego_vazquez — Thu, 27 Sep 2018 14:49:49 GMT

Apply what I wrote you earlier but with the months you need

Re: How to calculate accumulative value

johnca — Thu, 27 Sep 2018 16:39:14 GMT

There are so many versions of performing cumulative sums in the script. Here's one...

Re: Cumulative sum in script