topic Total Column in QlikView https://community.qlik.com/t5/QlikView/Total-Column/m-p/289943#M1203935 <HTML><HEAD></HEAD><BODY><P>If it´s a Pivot Table, see Properties&gt;Presentation&gt;ShowPartial sums for CODCPT</P><P>If it´s a Straith Table, create a new expression: Column(1) + Column(2)</P><P>Hope it helps.</P></BODY></HTML> Tue, 23 Nov 2010 18:14:30 GMT fernandotoledo 2010-11-23T18:14:30Z Total Column https://community.qlik.com/t5/QlikView/Total-Column/m-p/289942#M1203934 <HTML><HEAD></HEAD><BODY><P>Hi People:</P><P>Easy or not but i cant make the column "Total"</P><P>Any idea?</P><P>Regards</P><P>César Estrada</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 246pt; border-collapse: collapse;" width="327"><COLGROUP><COL style="width: 29pt; mso-width-source: userset; mso-width-alt: 1389;" width="38" /><COL style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" width="49" /><COL span="3" style="width: 60pt;" width="80" /></COLGROUP><TBODY><TR height="20" style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #dbe5f1; width: 29pt; height: 15pt; border-top: #d4d0c8; border-right: #d4d0c8;" width="38"><STRONG>Year</STRONG></TD><TD class="xl64" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #dbe5f1; width: 37pt; border-top: #d4d0c8; border-right: #d4d0c8;" width="49"><STRONG>Month</STRONG></TD><TD class="xl64" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #dbe5f1; width: 60pt; border-top: #d4d0c8; border-right: #d4d0c8;" width="80"><STRONG>CODCPT</STRONG></TD><TD class="xl64" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #dbe5f1; width: 60pt; border-top: #d4d0c8; border-right: #d4d0c8;" width="80"><STRONG>Amount</STRONG></TD><TD style="background-color: transparent; width: 60pt; border: #d4d0c8;" width="80"><STRONG></STRONG></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="background-color: transparent; height: 15pt; border: #d4d0c8;">2010</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">4</TD><TD style="background-color: transparent; border: #d4d0c8;">DIF020</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">310</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="background-color: transparent; height: 15pt; border: #d4d0c8;">2010</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">9</TD><TD style="background-color: transparent; border: #d4d0c8;">DIF020</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">160</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="background-color: transparent; height: 15pt; border: #d4d0c8;">2010</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">10</TD><TD style="background-color: transparent; border: #d4d0c8;">DIF014</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">80</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" height="20" style="background-color: transparent; height: 15pt; border: #d4d0c8;">2010</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">12</TD><TD style="background-color: transparent; border: #d4d0c8;">DIF014</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">150</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="background-color: transparent; height: 15pt; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD style="background-color: transparent; border: #d4d0c8;"></TD></TR><TR height="20" style="height: 15pt;"><TD class="xl64" height="20" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #dbe5f1; height: 15pt; border-top: #d4d0c8; border-right: #d4d0c8;"><STRONG>Year</STRONG></TD><TD class="xl64" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #dbe5f1; border-top: #d4d0c8; border-right: #d4d0c8;"><STRONG>Month</STRONG></TD><TD class="xl64" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #dbe5f1; border-top: #d4d0c8; border-right: #d4d0c8;"><STRONG>DIF014</STRONG></TD><TD class="xl64" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #dbe5f1; border-top: #d4d0c8; border-right: #d4d0c8;"><STRONG>DIF020</STRONG></TD><TD class="xl70" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: #00b0f0; border-top: #d4d0c8; border-right: #d4d0c8;"><STRONG>Total</STRONG></TD></TR><TR height="20" style="height: 15pt;"><TD class="xl67" height="80" rowspan="4" style="border-bottom: #95b3d7 0.5pt solid; border-left: #d4d0c8; background-color: transparent; width: 29pt; height: 60pt; border-top: #95b3d7; border-right: #d4d0c8;" width="38"><STRONG>2010</STRONG></TD><TD class="xl63" style="background-color: transparent; border: #d4d0c8;">4</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">310</TD><TD align="right" class="xl71" style="background-color: #00b0f0; border: #d4d0c8;">310</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl63" height="20" style="background-color: transparent; height: 15pt; border: #d4d0c8;">9</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">160</TD><TD align="right" class="xl71" style="background-color: #00b0f0; border: #d4d0c8;">160</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl63" height="20" style="background-color: transparent; height: 15pt; border: #d4d0c8;">10</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">80</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD align="right" class="xl71" style="background-color: #00b0f0; border: #d4d0c8;">80</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl63" height="20" style="background-color: transparent; height: 15pt; border: #d4d0c8;">12</TD><TD align="right" style="background-color: transparent; border: #d4d0c8;">150</TD><TD style="background-color: transparent; border: #d4d0c8;"></TD><TD align="right" class="xl71" style="background-color: #00b0f0; border: #d4d0c8;">150</TD></TR><TR height="20" style="height: 15pt;"><TD class="xl65" height="20" style="border-bottom: #d4d0c8; border-left: #d4d0c8; background-color: #dbe5f1; height: 15pt; border-top: #95b3d7; border-right: #d4d0c8;"><STRONG>Total</STRONG></TD><TD class="xl65" style="border-bottom: #d4d0c8; border-left: #d4d0c8; background-color: #dbe5f1; border-top: #95b3d7 0.5pt solid; border-right: #d4d0c8;"><STRONG></STRONG></TD><TD align="right" class="xl66" style="border-bottom: #d4d0c8; border-left: #d4d0c8; background-color: #dbe5f1; border-top: #95b3d7 0.5pt solid; border-right: #d4d0c8;"><STRONG>230</STRONG></TD><TD align="right" class="xl66" style="border-bottom: #d4d0c8; border-left: #d4d0c8; background-color: #dbe5f1; border-top: #95b3d7 0.5pt solid; border-right: #d4d0c8;"><STRONG>470</STRONG></TD><TD align="right" class="xl72" style="border-bottom: #d4d0c8; border-left: #d4d0c8; background-color: #00b0f0; border-top: #95b3d7 0.5pt solid; border-right: #d4d0c8;"><STRONG>700</STRONG></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P></P></BODY></HTML> Tue, 23 Nov 2010 17:49:25 GMT https://community.qlik.com/t5/QlikView/Total-Column/m-p/289942#M1203934 2010-11-23T17:49:25Z Total Column https://community.qlik.com/t5/QlikView/Total-Column/m-p/289943#M1203935 <HTML><HEAD></HEAD><BODY><P>If it´s a Pivot Table, see Properties&gt;Presentation&gt;ShowPartial sums for CODCPT</P><P>If it´s a Straith Table, create a new expression: Column(1) + Column(2)</P><P>Hope it helps.</P></BODY></HTML> Tue, 23 Nov 2010 18:14:30 GMT https://community.qlik.com/t5/QlikView/Total-Column/m-p/289943#M1203935 fernandotoledo 2010-11-23T18:14:30Z Total Column https://community.qlik.com/t5/QlikView/Total-Column/m-p/289944#M1203936 <HTML><HEAD></HEAD><BODY><P>Hello!!</P><P>Yes a Pivot Table, and work for me the "Show Partial Sums"</P><P>THANKS!!!</P><P>Regards</P><P>César Estrada</P></BODY></HTML> Tue, 23 Nov 2010 18:22:05 GMT https://community.qlik.com/t5/QlikView/Total-Column/m-p/289944#M1203936 2010-11-23T18:22:05Z