Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Labels (1)
1 Reply
Not applicable
Author

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