topic Re: Chart showing incorrect Total in QlikView https://community.qlik.com/t5/QlikView/Chart-showing-incorrect-Total/m-p/533612#M480604 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P></BODY></HTML> Sat, 16 Nov 2013 22:59:38 GMT swuehl 2013-11-16T22:59:38Z Chart showing incorrect Total https://community.qlik.com/t5/QlikView/Chart-showing-incorrect-Total/m-p/533611#M480603 <HTML><HEAD></HEAD><BODY><P><BR />Hello</P><P><SPAN style="color: #1f497d;">I am having difficulty with a calculation and wanted to see if anyone could help.&nbsp; I’ve attached the QVW in case that helps you.</SPAN></P><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Basically the Count and Sum Days and Days in Que at the top of the table are calculating because of the Total mode.&nbsp; However in the Chart the Total Mode is grayed out so I don’t know how to get the Average Days in Que to be 35 instead of 61.</SPAN></P><P><SPAN style="color: #1f497d; font-size: 11pt; font-family: 'Calibri','sans-serif';"> <SPAN style="font-family: 'Calibri','sans-serif'; color: #1f497d; font-size: 11pt;"> I'm not sure why I have to use the Total Mode I just found that it worked to calculate the correct sum for days<IMG alt="spreadsheet.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/49098_spreadsheet.JPG" style="width: 620px; height: 153px;" /><IMG alt="Spreadsheet Total mode.JPG" class="jive-image" src="/legacyfs/online/49106_Spreadsheet Total mode.JPG" /><IMG alt="Chart.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/49107_Chart.JPG" style="width: 620px; height: 187px;" /><IMG alt="Total Mode Chart.JPG" class="jive-image" src="/legacyfs/online/49108_Total Mode Chart.JPG" /></SPAN></SPAN></P></BODY></HTML> Sat, 16 Nov 2013 22:17:22 GMT https://community.qlik.com/t5/QlikView/Chart-showing-incorrect-Total/m-p/533611#M480603 kstroupe 2013-11-16T22:17:22Z Re: Chart showing incorrect Total https://community.qlik.com/t5/QlikView/Chart-showing-incorrect-Total/m-p/533612#M480604 <HTML><HEAD></HEAD><BODY><P>Maybe like attached?</P></BODY></HTML> Sat, 16 Nov 2013 22:59:38 GMT https://community.qlik.com/t5/QlikView/Chart-showing-incorrect-Total/m-p/533612#M480604 swuehl 2013-11-16T22:59:38Z Re: Chart showing incorrect Total https://community.qlik.com/t5/QlikView/Chart-showing-incorrect-Total/m-p/533613#M480605 <HTML><HEAD></HEAD><BODY><P>Yep that was exactly it...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />&nbsp; Thank you so much for your help.</P></BODY></HTML> Sat, 16 Nov 2013 23:07:21 GMT https://community.qlik.com/t5/QlikView/Chart-showing-incorrect-Total/m-p/533613#M480605 kstroupe 2013-11-16T23:07:21Z