topic Re: total for row and column in QlikView https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97569#M757479 <HTML><HEAD></HEAD><BODY><P>remove the 'Partial sum' for field 'Type'.</P></BODY></HTML> Wed, 05 Sep 2018 15:45:52 GMT neelamsaroha157 2018-09-05T15:45:52Z total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97560#M757469 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P><A _jive_internal="true" data-avatarid="3256" data-externalid="" data-online="false" data-presence="null" data-userid="34510" data-username="kaushik.solanki" href="https://community.qlik.com/people/kaushik.solanki" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;" target="_blank">Kaushik Solanki</A><SPAN style="color: #a9a9a9; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;"> </SPAN></P><P><A _jive_internal="true" data-avatarid="12595" data-externalid="" data-online="false" data-presence="null" data-userid="226258" data-username="felipedl" href="https://community.qlik.com/people/felipedl" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;" target="_blank">Felip Drechsler</A><SPAN style="color: #a9a9a9; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;"> </SPAN></P><P>i want to achieve the grand total column for both&nbsp;&nbsp;&nbsp; last row and last column&nbsp; as grand total</P><P></P><P></P><P>i have attached sample and result </P><P></P><P></P><P>can anyone help me on this??</P><P></P><P></P><P></P><P></P><P>Thanks</P><P>Sony</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97560#M757469 soniasweety 2020-11-25T16:16:04Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97561#M757471 <HTML><HEAD></HEAD><BODY><P>Sony,</P><P></P><P>This is very vague</P></BODY></HTML> Wed, 05 Sep 2018 14:49:00 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97561#M757471 siddharth_s3 2018-09-05T14:49:00Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97562#M757472 <HTML><HEAD></HEAD><BODY><P>i want to show grand total&nbsp; for&nbsp; last row and last column&nbsp; in qlikview pivot table</P></BODY></HTML> Wed, 05 Sep 2018 14:51:15 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97562#M757472 soniasweety 2018-09-05T14:51:15Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97563#M757473 <HTML><HEAD></HEAD><BODY><P>What is the issue you are facing?? isn't turning on the partial sum for product and Quarter not working???</P></BODY></HTML> Wed, 05 Sep 2018 14:55:18 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97563#M757473 neelamsaroha157 2018-09-05T14:55:18Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97564#M757474 <HTML><HEAD></HEAD><BODY><P>hi</P><P>look at the attach example isn't it what you are looking for</P></BODY></HTML> Wed, 05 Sep 2018 15:00:57 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97564#M757474 lironbaram 2018-09-05T15:00:57Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97565#M757475 <HTML><HEAD></HEAD><BODY><P>exactly.. what you have done?&nbsp; i cant find the changes?</P></BODY></HTML> Wed, 05 Sep 2018 15:06:17 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97565#M757475 soniasweety 2018-09-05T15:06:17Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97566#M757476 <HTML><HEAD></HEAD><BODY><P>Hi</P><P><STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/lironbaram">lironbaram</A> </STRONG> can you explain me how it done?</P><P></P><P>how you got last column as total ?</P></BODY></HTML> Wed, 05 Sep 2018 15:13:17 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97566#M757476 soniasweety 2018-09-05T15:13:17Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97567#M757477 <HTML><HEAD></HEAD><BODY><P>you just need to tick on the 'show partial sum' for the Quarter.</P></BODY></HTML> Wed, 05 Sep 2018 15:17:13 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97567#M757477 neelamsaroha157 2018-09-05T15:17:13Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97568#M757478 <HTML><HEAD></HEAD><BODY><P>but if i have multiple measures&nbsp; im getting multiple rows for total.</P><P><STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-avatarid="-1" data-userid="210420" data-username="neelamsaroha1575" href="https://community.qlik.com/people/neelamsaroha1575" style="padding: 0 3px 0 0; font-weight: inherit; font-style: inherit; font-size: 1.1em; font-family: inherit; color: #3778c7;">Neelam Sehrawat</A></STRONG></P><P>attached you can see </P></BODY></HTML> Wed, 05 Sep 2018 15:40:49 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97568#M757478 soniasweety 2018-09-05T15:40:49Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97569#M757479 <HTML><HEAD></HEAD><BODY><P>remove the 'Partial sum' for field 'Type'.</P></BODY></HTML> Wed, 05 Sep 2018 15:45:52 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97569#M757479 neelamsaroha157 2018-09-05T15:45:52Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97570#M757480 <HTML><HEAD></HEAD><BODY><P>this is not my requirment</P></BODY></HTML> Wed, 05 Sep 2018 15:50:27 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97570#M757480 soniasweety 2018-09-05T15:50:27Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97571#M757481 <HTML><HEAD></HEAD><BODY><P>am attaching my Qvw .. in that i have total&nbsp;&nbsp;&nbsp; aS&nbsp; measure coming from data only which sum(Sw+Hw)</P><P></P><P>now i want&nbsp; that total&nbsp; as grand total </P></BODY></HTML> Wed, 05 Sep 2018 15:53:13 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97571#M757481 soniasweety 2018-09-05T15:53:13Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97572#M757482 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; sir <A _jive_internal="true" data-avatarid="7439" data-externalid="" data-online="false" data-presence="null" data-userid="61824" data-username="marcowedel" href="https://community.qlik.com/people/marcowedel" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;">Marco Wedel</A><SPAN style="color: #a9a9a9; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">&nbsp;&nbsp; any work around?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; only total&nbsp; +total&nbsp; as grand total&nbsp;&nbsp; not each expression sum&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #a9a9a9; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;"><BR /></SPAN></P><P><SPAN style="color: #a9a9a9; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;"><BR /></SPAN></P></BODY></HTML> Wed, 05 Sep 2018 17:08:05 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97572#M757482 soniasweety 2018-09-05T17:08:05Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97573#M757483 <HTML><HEAD></HEAD><BODY><P>HI Sony,</P><P></P><P>Is this what you need?</P><P></P><P><IMG alt="sample.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212750_sample.png" style="height: 382px; width: 620px;" /></P></BODY></HTML> Wed, 05 Sep 2018 17:59:46 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97573#M757483 felipedl 2018-09-05T17:59:46Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97574#M757484 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/felipedl">felipedl</A></STRONG></P><P></P><P>No its not my requirment,</P><P></P><P>because the total&nbsp;&nbsp; expression is getting from data .&nbsp;&nbsp; so only&nbsp;&nbsp;&nbsp; that total should&nbsp; sum up.. not type values.</P></BODY></HTML> Thu, 06 Sep 2018 05:19:44 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97574#M757484 soniasweety 2018-09-06T05:19:44Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97575#M757485 <HTML><HEAD></HEAD><BODY><P>i want only sub total sum of quarter only not for types and not for each measures .&nbsp; </P></BODY></HTML> Thu, 06 Sep 2018 05:28:09 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97575#M757485 soniasweety 2018-09-06T05:28:09Z Re: total for row and column https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97576#M757486 <HTML><HEAD></HEAD><BODY><P>Hi <A _jive_internal="true" data-avatarid="1025" data-externalid="" data-online="false" data-presence="null" data-userid="133561" data-username="settu_periasamy" href="https://community.qlik.com/people/settu_periasamy" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;">Settu Periyasasamy </A>‌&nbsp;&nbsp; any workaround?</P></BODY></HTML> Thu, 06 Sep 2018 06:11:58 GMT https://community.qlik.com/t5/QlikView/total-for-row-and-column/m-p/97576#M757486 soniasweety 2018-09-06T06:11:58Z