topic Accumulated Values in Script in QlikView

Accumulated Values in Script

Anonymous — Thu, 22 Mar 2018 15:55:38 GMT

Hello,

I am trying to write a script to accumulate values by month year in a table. This would be having the values for each month (January, February, etc) and then right in front of the the accumulated values per month year; January of every year would be the only month with the accumulated value equal to its value, the rest would add up the past month year value plus the current month year value, and the hole thing will start over carrying the accumulated values at the end of that year, and then star over.

Do you have any suggestion as how can I accoumplish this?

Thank you in advance for your help.

Re: Accumulated Values in Script

sunny_talwar — Thu, 22 Mar 2018 16:21:36 GMT

You will need to use Peek() vs Previous() – When to Use Each to get this done.

Also, check here

https://qlikcentral.com/2016/01/25/cumulative-values-in-the-script-using-peek/

Re: Accumulated Values in Script

Anonymous — Thu, 22 Mar 2018 16:55:17 GMT

Thank you! This is very helpful.