topic Re: How to either avoid or make disappear the total column text in QlikView https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411079#M812177 <HTML><HEAD></HEAD><BODY><P>hello!</P><P></P><P>No, you can't get rid of the the Non-Payable...</P></BODY></HTML> Tue, 26 Sep 2017 14:27:34 GMT andrei_delta 2017-09-26T14:27:34Z How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411075#M812173 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">Hi! Dear </SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">appreciate if a solution is proposed in order to either avoid being appeared term " <SPAN style="text-decoration: underline;"><STRONG>NON PAYABLE' in the last row or to make it disappear in the row. But this needs to be shown as it is in all other rows! </STRONG></SPAN></SPAN></P><P></P><P></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177692_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></SPAN></P><P></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">Thanks</SPAN></P><P></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">Neville</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411075#M812173 nevilledhamsiri 2020-11-25T16:16:04Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411076#M812174 <HTML><HEAD></HEAD><BODY><P>Have you tried Label for Totals on Presentation tab</P><P></P><P></P><P></P><P><IMG alt="LabelsforTotal.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177695_LabelsforTotal.PNG" style="width: 620px; height: 550px;" /></P></BODY></HTML> Mon, 25 Sep 2017 17:23:47 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411076#M812174 vvira1316 2017-09-25T17:23:47Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411077#M812175 <HTML><HEAD></HEAD><BODY><P>Hi, Viran, will you elaborate how this is done in order to make it disappear. I followed what you said there I do not understand how that is proceeded!</P><P></P><P>Rgd</P><P></P><P>Neville</P></BODY></HTML> Mon, 25 Sep 2017 17:32:39 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411077#M812175 nevilledhamsiri 2017-09-25T17:32:39Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411078#M812176 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please see attached. If you are looking for a different information then please share what you are expecting.</P><P></P><P></P><P></P><P><IMG alt="LabelsforTotal2.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177701_LabelsforTotal2.PNG" style="width: 620px; height: 236px;" /></P></BODY></HTML> Mon, 25 Sep 2017 18:25:44 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411078#M812176 vvira1316 2017-09-25T18:25:44Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411079#M812177 <HTML><HEAD></HEAD><BODY><P>hello!</P><P></P><P>No, you can't get rid of the the Non-Payable...</P></BODY></HTML> Tue, 26 Sep 2017 14:27:34 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411079#M812177 andrei_delta 2017-09-26T14:27:34Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411080#M812178 <HTML><HEAD></HEAD><BODY><P>You can try something like this:</P><P></P><P>If( Dimensionality() &gt; 0,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum( Field ),</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ''</P><P>)</P><P></P><P>Good luck</P><P>Oscar</P></BODY></HTML> Tue, 26 Sep 2017 14:40:33 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411080#M812178 oscar_ortiz 2017-09-26T14:40:33Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411081#M812179 <HTML><HEAD></HEAD><BODY><P>Dear Oscar,</P><P>This is what you propose! the text 'Non Payable" is an expression so is it possible to apply this. Could you please elaborate more on this. Also the expression you propose carries a comma &amp; inward comma &amp; so on which are vague since it is not on a straight line. Please rewrite this.</P><P></P><P>Thanks In advance!</P><P></P><P>If( Dimensionality() &gt; 0,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum( Field ),</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ''</P><P>)</P></BODY></HTML> Wed, 27 Sep 2017 16:21:45 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411081#M812179 nevilledhamsiri 2017-09-27T16:21:45Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411082#M812180 <HTML><HEAD></HEAD><BODY><P>I like to break out my expression, it makes it a bit easier to read:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If( Dimensionality() &gt; 0,&nbsp;&nbsp;&nbsp;&nbsp; //&nbsp;&nbsp;&nbsp;&nbsp; Condition to test</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; Sum( Field ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //&nbsp;&nbsp;&nbsp;&nbsp; Then</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Else</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</P><P></P><P>Written as a single line:</P><P></P><P>If ( Dimensionality() &gt; 0, Your Expression goes here, '' )</P><P></P><P>good luck</P><P>Oscar</P></BODY></HTML> Wed, 27 Sep 2017 16:26:33 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411082#M812180 oscar_ortiz 2017-09-27T16:26:33Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411083#M812181 <HTML><HEAD></HEAD><BODY><P>Dear Oscar,</P><P>Thanks a lot. amazing! It simply worked fine.</P><P></P><P>Regds</P><P></P><P>Neville</P></BODY></HTML> Wed, 27 Sep 2017 16:34:55 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411083#M812181 nevilledhamsiri 2017-09-27T16:34:55Z Re: How to either avoid or make disappear the total column text https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411084#M812182 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit;">Not sure if you solved your issue.&nbsp; But if you have would you mind closing the thread.</SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-containerid="2001" data-containertype="14" data-objectid="14806" data-objecttype="102" href="https://community.qlik.com/docs/DOC-14806" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Oscar</P></BODY></HTML> Wed, 27 Sep 2017 16:37:51 GMT https://community.qlik.com/t5/QlikView/How-to-either-avoid-or-make-disappear-the-total-column-text/m-p/1411084#M812182 oscar_ortiz 2017-09-27T16:37:51Z