topic Subtotal in straight table in QlikView https://community.qlik.com/t5/QlikView/Subtotal-in-straight-table/m-p/1335715#M411995 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Thanks in advance,</P><P></P><P>My requirement is suppose i have 10 location in straight table , but i have to show only one location with there expression ,</P><P>but subtotal should have sum of all 10 rows.</P><P></P><P>bellow <SPAN style="color: #ff0000;">All Locations</SPAN> is my Subtotal row.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 930px;"><TBODY><TR><TD class="xl64" height="17" width="234"> Summary</TD><TD class="xl63" width="87">#Ordered</TD><TD class="xl63" width="87">#Short</TD><TD class="xl63" width="87">#Sub</TD><TD class="xl63" width="87">#All</TD><TD class="xl63" width="87">%Short</TD><TD class="xl63" width="87">%Sub</TD><TD class="xl63" width="87">%All</TD><TD class="xl63" width="87">% Avail</TD></TR><TR><TD class="xl65" height="17"><SPAN style="color: #ff0000;">All L</SPAN><SPAN style="color: #ff0000;">ocations</SPAN></TD><TD class="xl66">4076</TD><TD class="xl66">177</TD><TD class="xl66">126</TD><TD class="xl66">303</TD><TD class="xl67">4.34%</TD><TD class="xl67">3.09%</TD><TD class="xl67">7.43%</TD><TD class="xl68">98.30%</TD></TR><TR><TD class="xl69" height="20">132 Delhi</TD><TD class="xl70">468</TD><TD class="xl70">27</TD><TD class="xl70">18</TD><TD class="xl70">45</TD><TD class="xl71">5.77%</TD><TD class="xl71">3.85%</TD><TD class="xl71">9.62%</TD><TD class="xl72">99.20%</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P><P>Sunilkumar</P></BODY></HTML> Thu, 08 Jun 2017 13:04:14 GMT sunil1989 2017-06-08T13:04:14Z Subtotal in straight table https://community.qlik.com/t5/QlikView/Subtotal-in-straight-table/m-p/1335715#M411995 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Thanks in advance,</P><P></P><P>My requirement is suppose i have 10 location in straight table , but i have to show only one location with there expression ,</P><P>but subtotal should have sum of all 10 rows.</P><P></P><P>bellow <SPAN style="color: #ff0000;">All Locations</SPAN> is my Subtotal row.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 930px;"><TBODY><TR><TD class="xl64" height="17" width="234"> Summary</TD><TD class="xl63" width="87">#Ordered</TD><TD class="xl63" width="87">#Short</TD><TD class="xl63" width="87">#Sub</TD><TD class="xl63" width="87">#All</TD><TD class="xl63" width="87">%Short</TD><TD class="xl63" width="87">%Sub</TD><TD class="xl63" width="87">%All</TD><TD class="xl63" width="87">% Avail</TD></TR><TR><TD class="xl65" height="17"><SPAN style="color: #ff0000;">All L</SPAN><SPAN style="color: #ff0000;">ocations</SPAN></TD><TD class="xl66">4076</TD><TD class="xl66">177</TD><TD class="xl66">126</TD><TD class="xl66">303</TD><TD class="xl67">4.34%</TD><TD class="xl67">3.09%</TD><TD class="xl67">7.43%</TD><TD class="xl68">98.30%</TD></TR><TR><TD class="xl69" height="20">132 Delhi</TD><TD class="xl70">468</TD><TD class="xl70">27</TD><TD class="xl70">18</TD><TD class="xl70">45</TD><TD class="xl71">5.77%</TD><TD class="xl71">3.85%</TD><TD class="xl71">9.62%</TD><TD class="xl72">99.20%</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P><P>Sunilkumar</P></BODY></HTML> Thu, 08 Jun 2017 13:04:14 GMT https://community.qlik.com/t5/QlikView/Subtotal-in-straight-table/m-p/1335715#M411995 sunil1989 2017-06-08T13:04:14Z