Accumulated values in Chart

[#1]

Hi, i have a chart with accumulated values, everythings is o.k. until i make selection in country. Where there is no record for particular week, than there is no value, but that should be accumulated value, because previous week has a value. So every time when data missed record to particular week, accumulation did not work. I find solution to put matrix with all possible combinations of weeks and countries with zero values. After that, accumulation is o.k. in each week, because there is zero value instead of missing value for particular week. Is there any other solution to have nice accumulated values without inserting zero matrix of all possible combinations?  (I making sum for each category and i checked full accumulation, it is stacked bar chart ) Thanks

[sunny_talwar]

Would you be able to share a sample qvw to explore some options?

[#3]

I create some sample file as attachment.

[rahulpawarb]

Hello Jozef,

Hope you are doing well!

As per my primary analysis there are gaps in your data due to which you are facing issues in accumulation. Please share application with sample data, if possible. This will help us to further drill on this issue.

Regards!

Rahul