topic Problem with full accumulation and filter in QlikView

Problem with full accumulation and filter

Wed, 19 Nov 2014 13:15:04 GMT

Hi, I have a problem - after select filter the accumulation is not full.
Without filter :

With filter :

As you can see it start to accumulate from 0 without considering previous days.

To calculate expression i use simple count. Any idea how to solve this ?

Thanks in advance.

Wed, 19 Nov 2014 13:22:30 GMT

Hi Jackub,

its happening because when we use a filter then it will disregard the value because those are become zero.

So you can try the following

Rangesum(sum(amount), 0, count({1} total dimension))

in your expression.

Hope it helps

With regards

Harshita Gaur