topic Re: Total column. in QlikView https://community.qlik.com/t5/QlikView/Total-column/m-p/376790#M140460 <HTML><HEAD></HEAD><BODY><P>I need the sum of the expression SUM(Acumulado).</P></BODY></HTML> Thu, 09 Aug 2012 19:28:51 GMT Anonymous 2012-08-09T19:28:51Z Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376786#M140456 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">Hello everyone</SPAN>!</SPAN></P><P></P><P><SPAN class="hps">Do you have any way to total the column "Acumulado".</SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="389"><TBODY><TR><TD class="xl63" height="20" width="64">Produto</TD><TD class="xl64" width="64">Atual</TD><TD class="xl64" width="64">Anterior</TD><TD class="xl64" width="64">Acumulado</TD><TD class="xl68" width="133">Acumulado - correct</TD></TR><TR><TD class="xl65" height="20"> </TD><TD align="right">684</TD><TD>-</TD><TD>-</TD><TD align="right" class="xl69">5273</TD></TR><TR><TD class="xl65" height="20">A</TD><TD align="right">11</TD><TD>-</TD><TD align="right">11</TD><TD align="right" class="xl69">11</TD></TR><TR><TD class="xl65" height="20">B</TD><TD align="right">76</TD><TD align="right">11</TD><TD align="right">87</TD><TD align="right" class="xl69">87</TD></TR><TR><TD class="xl65" height="20">C</TD><TD align="right">10</TD><TD align="right">76</TD><TD align="right">97</TD><TD align="right" class="xl69">97</TD></TR><TR><TD class="xl65" height="20">D</TD><TD align="right">24</TD><TD align="right">10</TD><TD align="right">121</TD><TD align="right" class="xl69">121</TD></TR><TR><TD class="xl65" height="20">E</TD><TD align="right">82</TD><TD align="right">24</TD><TD align="right">203</TD><TD align="right" class="xl69">203</TD></TR><TR><TD class="xl65" height="20">F</TD><TD align="right">38</TD><TD align="right">82</TD><TD align="right">241</TD><TD align="right" class="xl69">241</TD></TR><TR><TD class="xl65" height="20">G</TD><TD align="right">8</TD><TD align="right">38</TD><TD align="right">249</TD><TD align="right" class="xl69">249</TD></TR><TR><TD class="xl65" height="20">H</TD><TD align="right">74</TD><TD align="right">8</TD><TD align="right">323</TD><TD align="right" class="xl69">323</TD></TR><TR><TD class="xl65" height="20">I</TD><TD align="right">95</TD><TD align="right">74</TD><TD align="right">418</TD><TD align="right" class="xl69">418</TD></TR><TR><TD class="xl65" height="20">J</TD><TD align="right">41</TD><TD align="right">95</TD><TD align="right">459</TD><TD align="right" class="xl69">459</TD></TR><TR><TD class="xl65" height="20">K</TD><TD align="right">82</TD><TD align="right">41</TD><TD align="right">541</TD><TD align="right" class="xl69">541</TD></TR><TR><TD class="xl65" height="20">L</TD><TD align="right">41</TD><TD align="right">82</TD><TD align="right">582</TD><TD align="right" class="xl69">582</TD></TR><TR><TD class="xl65" height="20">M</TD><TD align="right">38</TD><TD align="right">41</TD><TD align="right">620</TD><TD align="right" class="xl69">620</TD></TR><TR><TD class="xl65" height="20">N</TD><TD align="right">17</TD><TD align="right">38</TD><TD align="right">637</TD><TD align="right" class="xl69">637</TD></TR><TR><TD class="xl66" height="21">O</TD><TD align="right" class="xl67">47</TD><TD align="right" class="xl67">17</TD><TD align="right" class="xl67">684</TD><TD align="right" class="xl70">684</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 09 Aug 2012 18:55:02 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376786#M140456 Anonymous 2012-08-09T18:55:02Z Re: Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376787#M140457 <HTML><HEAD></HEAD><BODY><P>I've attached the fixed .qvw.</P><P></P><P>What I did:</P><P><IMG __jive_id="19678" class="jive-image-thumbnail jive-image" onclick="" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/19678_Capture.PNG" width="450" /></P></BODY></HTML> Thu, 09 Aug 2012 19:15:21 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376787#M140457 Nicole-Smith 2012-08-09T19:15:21Z Re: Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376788#M140458 <HTML><HEAD></HEAD><BODY><P>Have to be in the expression.</P></BODY></HTML> Thu, 09 Aug 2012 19:19:23 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376788#M140458 Anonymous 2012-08-09T19:19:23Z Re: Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376789#M140459 <HTML><HEAD></HEAD><BODY><P>I'm not sure what you want.&nbsp; What I did gives the results that you wanted in your first post...</P><P></P><P><IMG alt="Capture.PNG" class="jive-image" src="https://community.qlik.com/legacyfs/online/19682_Capture.PNG" /></P></BODY></HTML> Thu, 09 Aug 2012 19:22:13 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376789#M140459 Nicole-Smith 2012-08-09T19:22:13Z Re: Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376790#M140460 <HTML><HEAD></HEAD><BODY><P>I need the sum of the expression SUM(Acumulado).</P></BODY></HTML> Thu, 09 Aug 2012 19:28:51 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376790#M140460 Anonymous 2012-08-09T19:28:51Z Re: Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376791#M140461 <HTML><HEAD></HEAD><BODY><P>You need it where?&nbsp; It does exist on the table (if you do what I have in my above post) if that's where you want it...</P><P></P><P><IMG __jive_id="19683" class="jive-image" alt="Capture.PNG" src="https://community.qlik.com/legacyfs/online/19683_Capture.PNG" /></P></BODY></HTML> Thu, 09 Aug 2012 19:31:13 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376791#M140461 Nicole-Smith 2012-08-09T19:31:13Z Re: Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376792#M140462 <HTML><HEAD></HEAD><BODY><P>I really need the sum in the expression.</P></BODY></HTML> Thu, 09 Aug 2012 19:43:08 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376792#M140462 Anonymous 2012-08-09T19:43:08Z Re: Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376793#M140463 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">friend</SPAN>, <SPAN class="hps">a question like</SPAN> <SPAN class="hps">you did</SPAN> <SPAN class="hps">that</SPAN> <SPAN class="hps">colummna</SPAN> <SPAN class="hps">earlier,</SPAN> <SPAN class="hps">if I</SPAN> <SPAN class="hps">can</SPAN> <SPAN class="hps">pass the</SPAN> <SPAN class="hps">code</SPAN>, <SPAN class="hps">please</SPAN></P></BODY></HTML> Thu, 06 Sep 2012 21:36:43 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376793#M140463 2012-09-06T21:36:43Z Re: Total column. https://community.qlik.com/t5/QlikView/Total-column/m-p/376794#M140464 <HTML><HEAD></HEAD><BODY><P>This expression is not solved my case, but it works.</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>if</P><P></P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Dimensionality</SPAN><SPAN style="font-size: 8pt;">()=0,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">noofrows</SPAN><SPAN style="font-size: 8pt;">()*((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">DATA</SPAN><SPAN style="font-size: 8pt;">)+1)/2), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RowNo</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN></P><P><SPAN style="font-size: 8pt;">)) </SPAN></P></BODY></HTML> Mon, 10 Sep 2012 11:00:40 GMT https://community.qlik.com/t5/QlikView/Total-column/m-p/376794#M140464 Anonymous 2012-09-10T11:00:40Z