Full Accumulation problem

[stefangegg]

Hi to all,

this is my first question in this QlikCommunity here, so please don't hesitate to tell me if any information is missing.

I am wondering if you could help me regarding my accumulation problem:

in the attached dashboard, I only can see the accumulation using SetAnalysis, but if I use the "Full Accumulation" option, the values are only accumulated if in this specific dimension-value (here: Start_YearMonth, which means if the value exists in the respective month it will be accumulated)

Pls see the screenshot and app attached.

Many thanks for your help!

Best regards,
Stefan

[swuehl · Accepted solution]

One option could be to create all combinations between start date and methode in the script.

Or maybe have a look at the AsOf table concept for full accumulation

The As-Of Table

[stefangegg]

Many thanks, I thought there might be a more easier solution than creating all combinations - but your script is very easy, that's great! Thank you for sharing your knowledge.

I will have a look at the As-Of Table as well, but my problem is solved right now.