Accumulate data in an expression above a date in a chart
I would like to accumulate all data above a date and filtering with an 'if' statement.
I need the same key because I am using locations and a stacked bar chart it wont be good on the eye to have seperate keys.
I have been able to get a partial accumulation to work, but my new issues is that if the country is not present every month in the data, then the country wont carry forward and that is not what I want.
It's unclear to me what you want. Please read this blog post: Accumulations. If you need more help after reading this blog post please post a small qlikview document that explains the problem.
I have updated the original post with qvw and spreadsheet.
The goal is to report on current issues upto the month end date that are overdue issues.
Then from the month end date find the worst case scenario by adding all future overdue issues by concatenating the overdue date (based in the future) to the reporting date.
This will make a list that can then be filtered for issue level.
Ideally I would like to start the accumulation from the month end, so the current issues reported on month end and then add on all issues becoming overdue from that date.
I have been able to get a partial accumulation to work, but my new issues is that if the country is not present every month in the data, then the country wont carry forward and that is not what I want.
