topic Re: Straight Table Total in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426308#M807607 <HTML><HEAD></HEAD><BODY><P>Hi Experts help me on this</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌<A href="https://community.qlik.com/qlik-users/57428">kush141087</A>‌<A href="https://community.qlik.com/qlik-users/47027">dvqlikview</A>‌<A href="https://community.qlik.com/qlik-users/130924">avinashelite</A>‌</P><P></P><P>Regards,</P><P>Mahesh</P></BODY></HTML> Tue, 24 Oct 2017 19:44:11 GMT qlikview979 2017-10-24T19:44:11Z Straight Table Total https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426307#M807606 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>please find the attached file</P><P>I have one requirement&nbsp; my data is like</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="277"><TBODY><TR><TD height="20" width="85">Desc</TD><TD width="64">Country</TD><TD width="64">Revenue</TD><TD width="64">Adjust</TD></TR><TR><TD height="20">AB</TD><TD>IND</TD><TD align="right">0</TD><TD align="right">100</TD></TR><TR><TD height="20">BC</TD><TD>IND</TD><TD align="right">200</TD><TD align="right">0</TD></TR><TR><TD height="20">CA</TD><TD>IND</TD><TD align="right">300</TD><TD align="right">950</TD></TR><TR><TD height="20">DE</TD><TD>PAK</TD><TD align="right">0</TD><TD align="right">450</TD></TR><TR><TD height="20">EF</TD><TD>PAK</TD><TD align="right">500</TD><TD align="right">550</TD></TR><TR><TD height="20">FG</TD><TD>PAK</TD><TD align="right">600</TD><TD align="right">0</TD></TR><TR><TD height="20">LM</TD><TD>SL</TD><TD align="right">0</TD><TD align="right">250</TD></TR><TR><TD height="20">MN</TD><TD>SL</TD><TD align="right">800</TD><TD align="right">0</TD></TR><TR><TD height="20">OP</TD><TD>SL</TD><TD align="right">900</TD><TD align="right">150</TD></TR></TBODY></TABLE><P></P><P>Here&nbsp; total revenue is (3300) and total Adjust is(2450)</P><P></P><P>i have created one straight table and </P><P>Dim:- Desc</P><P>Exp:-Sum(Revenue) like below</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 149px;"><TBODY><TR><TD height="20" width="85">Desc</TD><TD width="64">Revenue</TD></TR><TR><TD align="right" class="xl65">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3300</TD></TR><TR><TD height="20">BC</TD><TD align="right">200</TD></TR><TR><TD height="20">CA</TD><TD align="right">300</TD></TR><TR><TD height="20">EF</TD><TD align="right">500</TD></TR><TR><TD height="20">FG</TD><TD align="right">600</TD></TR><TR><TD height="20">MN</TD><TD align="right">800</TD></TR><TR><TD height="20">OP</TD><TD align="right">900</TD></TR></TBODY></TABLE><P></P><P></P><P>in this straight table i have to add one row&nbsp; in this table&nbsp;&nbsp;&nbsp;&nbsp; it is TOTALADJUSR&nbsp;&nbsp; in Dimension column and sum(Adjust) in Expression row.</P><P></P><P>how can i achieve this.</P><P></P><P><STRONG>Final out put table is</STRONG></P><P><STRONG>&nbsp;&nbsp; </STRONG></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 149px;"><TBODY><TR><TD height="20" width="85">Desc</TD><TD width="64">Revenue</TD></TR><TR><TD align="right" class="xl65">3300</TD></TR><TR><TD height="20">BC</TD><TD align="right">200</TD></TR><TR><TD height="20">CA</TD><TD align="right">300</TD></TR><TR><TD height="20">EF</TD><TD align="right">500</TD></TR><TR><TD height="20">FG</TD><TD align="right">600</TD></TR><TR><TD height="20">MN</TD><TD align="right">800</TD></TR><TR><TD height="20">OP</TD><TD align="right">900</TD></TR><TR><TD height="20">Totaladjust</TD><TD align="right">2450</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Regards</P><P>mahesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426307#M807606 qlikview979 2020-11-25T16:16:04Z Re: Straight Table Total https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426308#M807607 <HTML><HEAD></HEAD><BODY><P>Hi Experts help me on this</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌<A href="https://community.qlik.com/qlik-users/57428">kush141087</A>‌<A href="https://community.qlik.com/qlik-users/47027">dvqlikview</A>‌<A href="https://community.qlik.com/qlik-users/130924">avinashelite</A>‌</P><P></P><P>Regards,</P><P>Mahesh</P></BODY></HTML> Tue, 24 Oct 2017 19:44:11 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426308#M807607 qlikview979 2017-10-24T19:44:11Z Re: Straight Table Total https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426309#M807608 <HTML><HEAD></HEAD><BODY><P>Check attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180789_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 24 Oct 2017 19:48:15 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426309#M807608 sunny_talwar 2017-10-24T19:48:15Z Re: Straight Table Total https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426310#M807609 <HTML><HEAD></HEAD><BODY><P>Thanks bro</P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />&nbsp;&nbsp;&nbsp; </P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P><P>Regards,</P><P>mahesh</P></BODY></HTML> Wed, 25 Oct 2017 01:24:31 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Total/m-p/1426310#M807609 qlikview979 2017-10-25T01:24:31Z