topic Re: stacked bar chart total error in QlikView https://community.qlik.com/t5/QlikView/stacked-bar-chart-total-error/m-p/438851#M163558 <HTML><HEAD></HEAD><BODY><P>There should be two charts in the attached QVW.&nbsp; The first, to the left, shows the following numbers in my version.&nbsp; The totals should sum up to 4415, yet these numbers don't.&nbsp; </P><P></P><P><IMG __jive_id="26887" class="jive-image-thumbnail jive-image" onclick="" alt="Stacked Bar Chart.PNG" src="/legacyfs/online/26887_Stacked Bar Chart.PNG" width="450" /></P></BODY></HTML> Fri, 14 Dec 2012 22:12:50 GMT 2012-12-14T22:12:50Z stacked bar chart total error https://community.qlik.com/t5/QlikView/stacked-bar-chart-total-error/m-p/438849#M163556 <HTML><HEAD></HEAD><BODY><P>I created a stacked bar chart showing a sum of contacts by 'ID' by quarter.&nbsp; I also set 'Values on Data Points' in my expression.&nbsp; The total displayed above the chart does not always reflect the correct total of all values.&nbsp; It seems to be excluding small values.&nbsp; 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.&nbsp; 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.&nbsp; The same chart displays different totals.</P><P></P><P>One more element&nbsp; -- 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).</P><P></P><P>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.&nbsp; I've attached a QVW example.&nbsp; </P></BODY></HTML> Fri, 14 Dec 2012 17:11:26 GMT https://community.qlik.com/t5/QlikView/stacked-bar-chart-total-error/m-p/438849#M163556 2012-12-14T17:11:26Z Re: stacked bar chart total error https://community.qlik.com/t5/QlikView/stacked-bar-chart-total-error/m-p/438850#M163557 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Its showig correct only.</P><P></P><P><IMG __jive_id="26885" class="jive-image-thumbnail jive-image" onclick="" alt="untitled.PNG" src="https://community.qlik.com/legacyfs/online/26885_untitled.PNG" width="450" /></P></BODY></HTML> Fri, 14 Dec 2012 17:50:17 GMT https://community.qlik.com/t5/QlikView/stacked-bar-chart-total-error/m-p/438850#M163557 MayilVahanan 2012-12-14T17:50:17Z Re: stacked bar chart total error https://community.qlik.com/t5/QlikView/stacked-bar-chart-total-error/m-p/438851#M163558 <HTML><HEAD></HEAD><BODY><P>There should be two charts in the attached QVW.&nbsp; The first, to the left, shows the following numbers in my version.&nbsp; The totals should sum up to 4415, yet these numbers don't.&nbsp; </P><P></P><P><IMG __jive_id="26887" class="jive-image-thumbnail jive-image" onclick="" alt="Stacked Bar Chart.PNG" src="/legacyfs/online/26887_Stacked Bar Chart.PNG" width="450" /></P></BODY></HTML> Fri, 14 Dec 2012 22:12:50 GMT https://community.qlik.com/t5/QlikView/stacked-bar-chart-total-error/m-p/438851#M163558 2012-12-14T22:12:50Z