topic Re: Grand Total in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818218#M1019328 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>I want a column called Grand Total which will be&nbsp; Embedded system (E+I+P) + Information security <SPAN style="font-size: 13.3333330154419px;">(E+I+P) + Virtualization <SPAN style="font-size: 13.3333330154419px;">(E+I+P) + Ethical <SPAN style="font-size: 13.3333330154419px;">(E+I+P) </SPAN></SPAN></SPAN></P><P></P><P>i.e. 155+92+83+92 = 422</P></BODY></HTML> Mon, 30 Mar 2015 10:09:53 GMT 2015-03-30T10:09:53Z Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818214#M1019324 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P><IMG alt="Table.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82300_Table.PNG" style="height: 327px; width: 620px;" /></P><P>I want to do the sum of all the four E+I+P columns. that is finding grand total.</P><P></P><P>I am not getting the solution for the same. Please help me </P><P>I have attached my qvw file.</P><P></P><P>Regards</P><P>Priyanka</P></BODY></HTML> Mon, 30 Mar 2015 09:43:09 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818214#M1019324 2015-03-30T09:43:09Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818215#M1019325 <HTML><HEAD></HEAD><BODY><P>WHAT your are getting for </P><P>E+I+P</P></BODY></HTML> Mon, 30 Mar 2015 09:48:41 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818215#M1019325 MK_QSL 2015-03-30T09:48:41Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818216#M1019326 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In attached QVW it is working.</P><P></P><P>What is the issue??</P><P>which value you are getting wrong??</P><P></P><P>Regards</P></BODY></HTML> Mon, 30 Mar 2015 09:49:30 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818216#M1019326 PrashantSangle 2015-03-30T09:49:30Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818217#M1019327 <HTML><HEAD></HEAD><BODY><P>looks correct to me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>what do you expect to see?</P></BODY></HTML> Mon, 30 Mar 2015 09:51:01 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818217#M1019327 giakoum 2015-03-30T09:51:01Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818218#M1019328 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>I want a column called Grand Total which will be&nbsp; Embedded system (E+I+P) + Information security <SPAN style="font-size: 13.3333330154419px;">(E+I+P) + Virtualization <SPAN style="font-size: 13.3333330154419px;">(E+I+P) + Ethical <SPAN style="font-size: 13.3333330154419px;">(E+I+P) </SPAN></SPAN></SPAN></P><P></P><P>i.e. 155+92+83+92 = 422</P></BODY></HTML> Mon, 30 Mar 2015 10:09:53 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818218#M1019328 2015-03-30T10:09:53Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818219#M1019329 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Go to presentation Tab-&gt; Select Subject -&gt;check Partial Sum</P><P></P><P>Regards,</P></BODY></HTML> Mon, 30 Mar 2015 10:14:32 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818219#M1019329 PrashantSangle 2015-03-30T10:14:32Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818220#M1019330 <HTML><HEAD></HEAD><BODY><P>=sum({&lt;Ex_Type={'External','Internal','Practical'}&gt;} TOTAL &lt;Student&gt; Marks)</P></BODY></HTML> Mon, 30 Mar 2015 10:14:39 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818220#M1019330 giakoum 2015-03-30T10:14:39Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818221#M1019331 <HTML><HEAD></HEAD><BODY><P>Hi ioannis,</P><P></P><P>Thanks for your reply.</P><P></P><P>The expression that you have provided gives me correct output, but the problem is that Grand Total column is displayed below all the subjects.</P><P></P><P>Attached is the screenshot for your reference</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82335_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Regards,</P><P>Priyanka</P></BODY></HTML> Mon, 30 Mar 2015 10:23:37 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818221#M1019331 2015-03-30T10:23:37Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818222#M1019332 <HTML><HEAD></HEAD><BODY><P>Hi Max,</P><P></P><P>The partial sum check box is disabled.</P><P><IMG class="image-1 jive-image" height="382" src="https://community.qlik.com/legacyfs/online/82336_pastedImage_0.png" style="width: 431.87898089172px; height: 382px;" width="432" /></P><P>Regards,</P><P>Priyanka</P></BODY></HTML> Mon, 30 Mar 2015 10:26:46 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818222#M1019332 2015-03-30T10:26:46Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818223#M1019333 <HTML><HEAD></HEAD><BODY><P>Alternatively you can make it a calculated dimension :</P><P>=Aggr(sum({&lt;Ex_Type={'External','Internal','Practical'}&gt;} TOTAL &lt;Student&gt; Marks), Student)</P><P></P><P>most likely this can be simplified further <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 30 Mar 2015 10:32:33 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818223#M1019333 giakoum 2015-03-30T10:32:33Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818224#M1019334 <HTML><HEAD></HEAD><BODY><P>hi priya</P><P>i am attaching sample example file Grand total of the pivot table</P></BODY></HTML> Mon, 30 Mar 2015 10:46:55 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818224#M1019334 2015-03-30T10:46:55Z Re: Grand Total in Pivot table https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818225#M1019335 <HTML><HEAD></HEAD><BODY><P>Hi Navven,</P><P></P><P>I am not able to resolve my problem with your solution.</P><P>can you please help me with the qvw file attached before.</P><P></P><P>Regards</P><P>Priyanka</P></BODY></HTML> Fri, 03 Apr 2015 11:34:09 GMT https://community.qlik.com/t5/QlikView/Grand-Total-in-Pivot-table/m-p/818225#M1019335 2015-04-03T11:34:09Z