topic Re: Problem in finding the total in QlikView https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500791#M556519 <HTML><HEAD></HEAD><BODY><P>am getting partial sum but i need the value as a separate column in the end of the table </P><P></P><P></P><P></P><P><BR />Regards</P></BODY></HTML> Fri, 19 Jul 2013 12:52:41 GMT techvarun 2013-07-19T12:52:41Z Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500785#M556513 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have a pivot table with year quarter and month i have computed total profit for monthwise and i need to show the total of all the three month value in last column.</P></BODY></HTML> Fri, 19 Jul 2013 12:41:56 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500785#M556513 techvarun 2013-07-19T12:41:56Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500786#M556514 <HTML><HEAD></HEAD><BODY><P>I need to show the sum of total of month April+May+June in last Column</P><P></P><P></P><P></P><P><BR />Thanks in Advance</P></BODY></HTML> Fri, 19 Jul 2013 12:43:12 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500786#M556514 techvarun 2013-07-19T12:43:12Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500787#M556515 <HTML><HEAD></HEAD><BODY><P>IN presentation check (near fields list) the field for which you need the sum ... (show partial sum)</P><P></P><P>hope it helps</P></BODY></HTML> Fri, 19 Jul 2013 12:44:03 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500787#M556515 alexandros17 2013-07-19T12:44:03Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500788#M556516 <HTML><HEAD></HEAD><BODY><P>Presentation TAB &gt;select Month ---check show partial Sums</P></BODY></HTML> Fri, 19 Jul 2013 12:48:59 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500788#M556516 2013-07-19T12:48:59Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500789#M556517 <HTML><HEAD></HEAD><BODY><P>the total field is a calculated field and i need the sum of all three months also a calculated field</P></BODY></HTML> Fri, 19 Jul 2013 12:51:34 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500789#M556517 techvarun 2013-07-19T12:51:34Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500790#M556518 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><STRONG>sum( Fieldname)</STRONG></P><P></P><P><STRONG>and in presentation tab select the field month then check show partial&nbsp; sum.</STRONG></P><P></P><P>******************************************************************</P><P></P><P>or try this</P><P>sum(total Fieldname)</P></BODY></HTML> Fri, 19 Jul 2013 12:52:01 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500790#M556518 2013-07-19T12:52:01Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500791#M556519 <HTML><HEAD></HEAD><BODY><P>am getting partial sum but i need the value as a separate column in the end of the table </P><P></P><P></P><P></P><P><BR />Regards</P></BODY></HTML> Fri, 19 Jul 2013 12:52:41 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500791#M556519 techvarun 2013-07-19T12:52:41Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500792#M556520 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">am getting partial sum but i need the value as a separate column in the end of the table</P><P></P><P></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><BR />Regards</P></BODY></HTML> Fri, 19 Jul 2013 12:53:16 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500792#M556520 techvarun 2013-07-19T12:53:16Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500793#M556521 <HTML><HEAD></HEAD><BODY><P>add this expression </P><P></P><P>aggr(sum(Fieldname), year, quarter)</P></BODY></HTML> Fri, 19 Jul 2013 12:55:11 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500793#M556521 alexandros17 2013-07-19T12:55:11Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500794#M556522 <HTML><HEAD></HEAD><BODY><P>add this expression </P><P></P><P>aggr(sum(Fieldname), year, quarter)</P></BODY></HTML> Fri, 19 Jul 2013 12:59:15 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500794#M556522 alexandros17 2013-07-19T12:59:15Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500795#M556523 <HTML><HEAD></HEAD><BODY><P>I have attached the qvw please check</P></BODY></HTML> Fri, 19 Jul 2013 13:08:50 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500795#M556523 techvarun 2013-07-19T13:08:50Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500796#M556524 <HTML><HEAD></HEAD><BODY><P>Hi techvarnun,</P><P>I've worked with your qvw, the result is that you must add the following expression (After Total):</P><P></P><P>aggr<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">NODISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Category</SPAN><SPAN style="font-size: 8pt;">={'Revenue'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Exchange Rate]</SPAN><SPAN style="font-size: 8pt;">*</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Total (Amount)]</SPAN><SPAN style="font-size: 8pt;">) - </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Category</SPAN><SPAN style="font-size: 8pt;">={'Costs'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Exchange Rate]</SPAN><SPAN style="font-size: 8pt;">*</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Total (Amount)]</SPAN><SPAN style="font-size: 8pt;">) ,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Category</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">Type</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">Quarter</SPAN><SPAN style="font-size: 8pt;">)<BR /></SPAN></P><P><SPAN style="font-size: 8pt;">This expression add a new column where all rows have total of quarter, if you need only one row with the total (but not a new row) delete NODISTINCT</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Hope it helps</SPAN></P></BODY></HTML> Mon, 22 Jul 2013 06:54:03 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500796#M556524 alexandros17 2013-07-22T06:54:03Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500797#M556527 <HTML><HEAD></HEAD><BODY><P>see the attachment</P></BODY></HTML> Mon, 22 Jul 2013 07:02:53 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500797#M556527 nizamsha 2013-07-22T07:02:53Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500798#M556530 <HTML><HEAD></HEAD><BODY><P>Sorry am on my qlikview personal edition</P><P></P><P></P><P></P><P><BR />Regards</P></BODY></HTML> Mon, 22 Jul 2013 07:53:28 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500798#M556530 techvarun 2013-07-22T07:53:28Z Re: Problem in finding the total https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500799#M556532 <HTML><HEAD></HEAD><BODY><P>IS that u want u want to add app+may+june and it should display in the next row</P><P>in presenttion enable show partical sums to month</P></BODY></HTML> Mon, 22 Jul 2013 08:07:08 GMT https://community.qlik.com/t5/QlikView/Problem-in-finding-the-total/m-p/500799#M556532 nizamsha 2013-07-22T08:07:08Z