Solved: Re: Full accumulation not working when null - Qlik Community

annabergendal · ‎2015-11-04

Hi,

how can I get full accumulation to work if there is null in the last dimension?

See attached.

As there is no status "OK" in month 11, it goes back to 0, not counting previuos months...

How can I solve this?

Thanks.

morganaaron · ‎2015-11-04

I think Manish's is a little neater, but the issue is if you are using your status as your count, you'll need to aggregate this in order to not accidentally add one when creating the values that don't yet exist.

I've counted the statuses into a new field and sum that instead - that way you can pick up any values that don't exist without counting them in the actual data.

View solution in original post

MK_QSL · ‎2015-11-04

Check enclosed file...

morganaaron · ‎2015-11-04

I think Manish's is a little neater, but the issue is if you are using your status as your count, you'll need to aggregate this in order to not accidentally add one when creating the values that don't yet exist.

I've counted the statuses into a new field and sum that instead - that way you can pick up any values that don't exist without counting them in the actual data.

annabergendal · ‎2015-11-04

Thanks to both of you!! Works perfect