Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=rangesum(above(count(ItemNumbers),0,rowno(total))) ?
Sorry I cannot post a sample as this is based on sensitive production data.
paste it with sample data.
Or you can scramble your data from the document properties menu/scrambling
Thank you for letting me know that trick!
Here is the scrambled QVW still showing the problem.
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):