topic Full Accumulation problem in QlikView

Full Accumulation problem

stefangegg — Wed, 16 Mar 2016 15:44:04 GMT

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

Re: Full Accumulation problem

swuehl — Wed, 16 Mar 2016 21:05:57 GMT

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

Re: Full Accumulation problem

stefangegg — Thu, 17 Mar 2016 14:53:31 GMT

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.