topic Hide some expression totals in pivot table in QlikView https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403273#M425173 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a pivot table with three expressions, however I only want to show a total for one of them.&nbsp; Is there a way to hide the ones I don't need? I know there is a "Show Partial Sums" option that can be turned on and off, however this is by dimension, not by expression.</P><P></P><P>Thank you!</P></BODY></HTML> Thu, 05 Oct 2017 17:25:01 GMT dukane24 2017-10-05T17:25:01Z Hide some expression totals in pivot table https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403273#M425173 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a pivot table with three expressions, however I only want to show a total for one of them.&nbsp; Is there a way to hide the ones I don't need? I know there is a "Show Partial Sums" option that can be turned on and off, however this is by dimension, not by expression.</P><P></P><P>Thank you!</P></BODY></HTML> Thu, 05 Oct 2017 17:25:01 GMT https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403273#M425173 dukane24 2017-10-05T17:25:01Z Re: Hide some expression totals in pivot table https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403274#M425174 <HTML><HEAD></HEAD><BODY><P>And if you check Expression Total in Total Mode just for the expression you want display the total?</P><P></P><P></P><P><IMG alt="" class="jive-image image-1" height="213" src="https://community.qlik.com/legacyfs/online/178756_pastedImage_1.png" style="width: 562px; height: 213.016px;" width="562" /></P></BODY></HTML> Thu, 05 Oct 2017 17:44:43 GMT https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403274#M425174 sergio0592 2017-10-05T17:44:43Z Re: Hide some expression totals in pivot table https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403275#M425175 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>The total mode section is greyed out - I don't believe it's available for pivot tables.</P><P></P><P>- Thank you</P></BODY></HTML> Thu, 05 Oct 2017 18:00:23 GMT https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403275#M425175 dukane24 2017-10-05T18:00:23Z Re: Hide some expression totals in pivot table https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403276#M425176 <HTML><HEAD></HEAD><BODY><P>Use a <SPAN class="Bold">dimensionality </SPAN>function.</P><P></P><P>If(<SPAN class="Bold">dimensionality() = "Total row nimber", '', Sum(Field))</SPAN></P></BODY></HTML> Thu, 05 Oct 2017 18:00:26 GMT https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403276#M425176 MarcoARaymundo 2017-10-05T18:00:26Z Re: Hide some expression totals in pivot table https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403277#M425177 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you!</P></BODY></HTML> Thu, 05 Oct 2017 18:24:24 GMT https://community.qlik.com/t5/QlikView/Hide-some-expression-totals-in-pivot-table/m-p/1403277#M425177 dukane24 2017-10-05T18:24:24Z