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

stacked bar chart total error

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. 

2 Replies
MayilVahanan

Hi

Its showig correct only.

untitled.PNG

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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. 

Stacked Bar Chart.PNG