topic straight table total % in QlikView https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172622#M42103 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR /> sum(Capacity-Demand)/Demand<BR />//may even need something like this<BR />(sum(Capacity-Demand))/Demand<BR />//or play around with num<BR />sum(Capacity-Demand)/num(Demand)<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>One of those combinations should work. QV needs more direction.</P></BODY></HTML> Tue, 24 Aug 2010 17:45:26 GMT 2010-08-24T17:45:26Z straight table total % https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172621#M42102 <HTML><HEAD></HEAD><BODY><P>i cant seem to get the total to display correctly or at all.</P><P>The total % should = <B>(capacity-demand)/demand</B></P><P>As you can see its displaying blank.</P><P>How can i get it to display the total expressed as a % ?<IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2206_sourceID:2206" /></P><P></P></BODY></HTML> Tue, 24 Aug 2010 16:17:42 GMT https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172621#M42102 2010-08-24T16:17:42Z straight table total % https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172622#M42103 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR /> sum(Capacity-Demand)/Demand<BR />//may even need something like this<BR />(sum(Capacity-Demand))/Demand<BR />//or play around with num<BR />sum(Capacity-Demand)/num(Demand)<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>One of those combinations should work. QV needs more direction.</P></BODY></HTML> Tue, 24 Aug 2010 17:45:26 GMT https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172622#M42103 2010-08-24T17:45:26Z straight table total % https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172623#M42104 <HTML><HEAD></HEAD><BODY><P>You'll need to specifiy an aggregation for all the data involved. Like Jacob said, but for the divisor as well.</P><P>sum(Capacity-Demand) / sum(Demand)</P><P>-Rob</P></BODY></HTML> Wed, 25 Aug 2010 00:14:05 GMT https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172623#M42104 rwunderlich 2010-08-25T00:14:05Z straight table total % https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172624#M42105 <HTML><HEAD></HEAD><BODY><P>dear all, i still cant get the correct % for all columns including the total column.</P><P>see picture below which shows the results from the different expressions you suggested</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3683.totals.bmp"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/3683.totals.bmp" /></A></P><P>are there any other ideas for expression/settings that will enable the table to display correct % for all months + the total column?</P></BODY></HTML> Wed, 25 Aug 2010 10:02:53 GMT https://community.qlik.com/t5/QlikView/straight-table-total/m-p/172624#M42105 2010-08-25T10:02:53Z