topic Re: pivot table not summarizing in QlikView https://community.qlik.com/t5/QlikView/pivot-table-not-summarizing/m-p/868601#M303787 <HTML><HEAD></HEAD><BODY><P>Perhaps the sum really is 0?</P><P>If not, try to post an example: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Mon, 04 May 2015 08:47:28 GMT Gysbert_Wassenaar 2015-05-04T08:47:28Z pivot table not summarizing https://community.qlik.com/t5/QlikView/pivot-table-not-summarizing/m-p/868600#M303786 <HTML><HEAD></HEAD><BODY><P>I have a plain and simple pivot table but my totals are not shown, why?</P><P></P><P>If i do the sum for the order number column, all works fine, but not for the amount; It just show zero</P><P>my code is</P><P>=sum(amount)</P><P>=sum(ordernumber)</P><P></P><P>ordernumber is a plain number like 201412345 while amount is a decimal with possible negatives.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Yes, i have checked the "show partial sum".</SPAN></P></BODY></HTML> Mon, 04 May 2015 08:43:49 GMT https://community.qlik.com/t5/QlikView/pivot-table-not-summarizing/m-p/868600#M303786 2015-05-04T08:43:49Z Re: pivot table not summarizing https://community.qlik.com/t5/QlikView/pivot-table-not-summarizing/m-p/868601#M303787 <HTML><HEAD></HEAD><BODY><P>Perhaps the sum really is 0?</P><P>If not, try to post an example: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Mon, 04 May 2015 08:47:28 GMT https://community.qlik.com/t5/QlikView/pivot-table-not-summarizing/m-p/868601#M303787 Gysbert_Wassenaar 2015-05-04T08:47:28Z Re: pivot table not summarizing https://community.qlik.com/t5/QlikView/pivot-table-not-summarizing/m-p/868602#M303788 <HTML><HEAD></HEAD><BODY><P>that was too easy; ok my fault <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> thx</P></BODY></HTML> Mon, 04 May 2015 08:59:04 GMT https://community.qlik.com/t5/QlikView/pivot-table-not-summarizing/m-p/868602#M303788 2015-05-04T08:59:04Z