Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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/
Thank you! This is very helpful.