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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart accumulation not making sense

I have a chart that suddenly is not showing the correct amount for the last "bar" in full accumulation mode. It would seem that the count on the last bar should be 132 since the second to last is 130, and the non-accumulation chart shows that the last one has a count of 2.

Is my assumption correct? Am I missing something maybe?

This is in Qlikview 9.

15 Replies
whiteline
Master II
Master II

=rangesum(above(count(ItemNumbers),0,rowno(total))) ?

Not applicable
Author

Sorry I cannot post a sample as this is based on sensitive production data.

whiteline
Master II
Master II

paste it with sample data.

Not applicable
Author

Or you can scramble your data from the document properties menu/scrambling

Not applicable
Author

Thank you for letting me know that trick!


Here is the scrambled QVW still showing the problem.

whiteline
Master II
Master II

In this case you can't do it with inter-record functions or with builtin accumulation.

Use the solution from this thread (the last one from John):

http://community.qlik.com/message/88613#88613