topic Re: Problem with Straight Table Totals in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239832#M851074 <HTML><HEAD></HEAD><BODY><P>Sushil, But Qlik Staight object took me direct. Why do we need to change again. Just for clarification</P></BODY></HTML> Tue, 07 Mar 2017 06:50:33 GMT Anil_Babu_Samineni 2017-03-07T06:50:33Z Problem with Straight Table Totals https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239828#M851070 <HTML><HEAD></HEAD><BODY><P>Hi all , </P><P>Below is Straight table , Actually the total Should Below Blue Mark , But It is Coming in Red Color Total . </P><P></P><P>What is problem in this Straight Table </P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="286" style="width: 431px; height: 288px;"><TBODY><TR><TD class="xl63" height="20" width="64">REGION</TD><TD class="xl63" style="border-left: none;" width="64">COUNTRY</TD><TD class="xl63" style="border-left: none;" width="64">BUSINESS</TD><TD class="xl63" style="border-left: none;" width="64">LENSBRAND</TD><TD class="xl63" style="border-left: none;" width="64">Net Sales</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;" width="64"> </TD><TD class="xl66" style="border-top: none; border-left: none;" width="64"> </TD><TD class="xl66" style="border-top: none; border-left: none;" width="64"> </TD><TD class="xl66" style="border-top: none; border-left: none;" width="64"> </TD><TD class="xl69" style="border-top: none; border-left: none;" width="64"><SPAN style="color: #ff6600;">156055</SPAN></TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">ASIA</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">H</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">L</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">H</TD><TD class="xl64" style="border-top: none; border-left: none;" width="64">29257</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">ASIA</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">H</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">L</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">L</TD><TD class="xl64" style="border-top: none; border-left: none;" width="64">13033</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">ASIA</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">H</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">L</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">O</TD><TD class="xl64" style="border-top: none; border-left: none;" width="64">15881</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">ASIA</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">H</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">L</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">P</TD><TD class="xl64" style="border-top: none; border-left: none;" width="64">90</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">ASIA</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">H</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">L</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">S</TD><TD class="xl64" style="border-top: none; border-left: none;" width="64">1114</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">ASIA</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">H</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">L</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">V</TD><TD class="xl64" style="border-top: none; border-left: none;" width="64">815</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">ASIA</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">H</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">L</TD><TD class="xl67" style="border-top: none; border-left: none;" width="64">-</TD><TD class="xl64" style="border-top: none; border-left: none;" width="64">96353</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD class="xl68" width="64">Total </TD><TD align="right" class="xl70"><SPAN style="color: #0000ff;">156543</SPAN></TD></TR></TBODY></TABLE><P></P><P>Please help me out of this .</P><P></P><P>Thanks in advance ,</P><P></P><P>Harish </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239828#M851070 munna1317 2020-11-25T16:16:04Z Re: Problem with Straight Table Totals https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239829#M851071 <HTML><HEAD></HEAD><BODY><P>I didn't face any issue here, Use simple <STRONG>sum([Net Sales])</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155398_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 07 Mar 2017 06:41:13 GMT https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239829#M851071 Anil_Babu_Samineni 2017-03-07T06:41:13Z Re: Problem with Straight Table Totals https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239830#M851072 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the expression tab &gt; Total Mode &gt; check for Sum of Rows</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Tue, 07 Mar 2017 06:41:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239830#M851072 sushil353 2017-03-07T06:41:42Z Re: Problem with Straight Table Totals https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239831#M851073 <HTML><HEAD></HEAD><BODY><P>Yes Got it Sushil Thanks for Immediate Replay </P></BODY></HTML> Tue, 07 Mar 2017 06:48:20 GMT https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239831#M851073 munna1317 2017-03-07T06:48:20Z Re: Problem with Straight Table Totals https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239832#M851074 <HTML><HEAD></HEAD><BODY><P>Sushil, But Qlik Staight object took me direct. Why do we need to change again. Just for clarification</P></BODY></HTML> Tue, 07 Mar 2017 06:50:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-Straight-Table-Totals/m-p/1239832#M851074 Anil_Babu_Samineni 2017-03-07T06:50:33Z