topic Total with Accumulation in QlikView https://community.qlik.com/t5/QlikView/Total-with-Accumulation/m-p/211154#M65517 <HTML><HEAD></HEAD><BODY><P>Hi Forum</P><P>I have a Straigth Table. I have to show the total (last row). This is the Amount (30 and 17). What can i Do ?</P><P><BR />Cod Val Type Amount Amount 2</P><P>1 10 Ing 10 0</P><P>2 20 Ing 30 0</P><P>3 5 Egr 0 5</P><P>4 5 Egr 0 10</P><P>5 7 Egr 0 17</P><P>TOTAL 30 17</P><P></P><P>I appreciate very much your suggestions .</P></BODY></HTML> Wed, 13 Jan 2010 17:00:19 GMT 2010-01-13T17:00:19Z Total with Accumulation https://community.qlik.com/t5/QlikView/Total-with-Accumulation/m-p/211154#M65517 <HTML><HEAD></HEAD><BODY><P>Hi Forum</P><P>I have a Straigth Table. I have to show the total (last row). This is the Amount (30 and 17). What can i Do ?</P><P><BR />Cod Val Type Amount Amount 2</P><P>1 10 Ing 10 0</P><P>2 20 Ing 30 0</P><P>3 5 Egr 0 5</P><P>4 5 Egr 0 10</P><P>5 7 Egr 0 17</P><P>TOTAL 30 17</P><P></P><P>I appreciate very much your suggestions .</P></BODY></HTML> Wed, 13 Jan 2010 17:00:19 GMT https://community.qlik.com/t5/QlikView/Total-with-Accumulation/m-p/211154#M65517 2010-01-13T17:00:19Z Total with Accumulation https://community.qlik.com/t5/QlikView/Total-with-Accumulation/m-p/211155#M65518 <HTML><HEAD></HEAD><BODY><P>Do you mean the totals should be 40 and 32?</P><P>If so, you can use the attached sample.</P><P></P><P>If not, you might want to look at the AGGR() statement.</P></BODY></HTML> Wed, 13 Jan 2010 18:56:07 GMT https://community.qlik.com/t5/QlikView/Total-with-Accumulation/m-p/211155#M65518 2010-01-13T18:56:07Z Total with Accumulation https://community.qlik.com/t5/QlikView/Total-with-Accumulation/m-p/211156#M65519 <HTML><HEAD></HEAD><BODY><P>Hi Mark</P><P>Thanks a lot for your reply !!</P><P>I use Agrr() Statement. Max(aggr(Amount2 , Cod , Type)). The total is OK.</P><P></P><P></P></BODY></HTML> Thu, 14 Jan 2010 15:04:24 GMT https://community.qlik.com/t5/QlikView/Total-with-Accumulation/m-p/211156#M65519 2010-01-14T15:04:24Z