Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Problem with full accumulation and filter

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

before.PNG.png

With filter :

after.PNG.png

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.

1 Reply
Not applicable

Re: Problem with full accumulation and filter

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