Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a stacked bar chart showing a sum of contacts by 'ID' by quarter. I also set 'Values on Data Points' in my expression. The total displayed above the chart does not always reflect the correct total of all values. It seems to be excluding small values. The sum of my initial chart values is 729+710+939+1225+803=4406 total (incorrect), even though once I download the chart values to Excel, they sum correctly to 4415. What makes this more unusual is if I stretch the chart vertically, making it very tall, the values change to 732+713+940+1226+804=4415 total, the correct answer. The same chart displays different totals.
One more element -- once I save this document to Qlikview Access Point, the same chart that gave an incorrect total when working on my desktop suddenly shows the correct totals (4415).
I found one other discussion on the forum that looked close (Values on Data Points for Small Values in Stacked Bar Chart/188419), but there was no resolution. I've attached a QVW example.
Hi
Its showig correct only.
There should be two charts in the attached QVW. The first, to the left, shows the following numbers in my version. The totals should sum up to 4415, yet these numbers don't.