topic adding a seperate row in a table in QlikView https://community.qlik.com/t5/QlikView/adding-a-seperate-row-in-a-table/m-p/333877#M1177249 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Please help me in implementing a table such as below.-</P><P></P><P>The first row is the sum(allocation) amount for individual months, dimension name to be given(not coming from database) ALLOCATION(synthetic).</P><P></P><P>The next rows are the sum(BALANCE) per DIVISION, for each month.</P><P></P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="left" height="20" style="border: #000000 1px solid;" width="121"><STRONG style="font-size: 12pt;">Division</STRONG></TD><TD align="left" style="border: #000000 1px solid;" width="67"><STRONG style="font-size: 12pt;">MONTH</STRONG></TD><TD align="right" style="border: #000000 1px solid;" width="67"><SPAN style="font-size: 12pt;">1</SPAN></TD><TD align="right" style="border: #000000 1px solid;" width="67"><SPAN style="font-size: 12pt;">2</SPAN></TD><TD align="right" style="border: #000000 1px solid;" width="67"><SPAN style="font-size: 12pt;">3</SPAN></TD><TD align="right" style="border: #000000 1px solid;" width="67"><SPAN style="font-size: 12pt;">4</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><STRONG style="font-size: 12pt;">ALLOCATION</STRONG></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;">0.4</TD><TD align="right" style="border: #000000 1px solid;">0.4</TD><TD align="right" style="border: #000000 1px solid;">0.4</TD><TD align="right" style="border: #000000 1px solid;">0.4</TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV1</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">600000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">160000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">750000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">1410000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV2</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">800000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">150000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">910000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">900000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV4</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">100000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">30000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">100000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">370000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV3</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">200000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">20000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">450000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">380000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV5</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">400000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">40000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">900000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">760000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV6</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">200000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">20000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">450000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">380000</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P></P><P>sample dats is attached herewith.</P><P></P><P></P><P>Thanks,</P><P>Sonika </P></BODY></HTML> Thu, 03 May 2012 11:01:17 GMT sonikajain 2012-05-03T11:01:17Z adding a seperate row in a table https://community.qlik.com/t5/QlikView/adding-a-seperate-row-in-a-table/m-p/333877#M1177249 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Please help me in implementing a table such as below.-</P><P></P><P>The first row is the sum(allocation) amount for individual months, dimension name to be given(not coming from database) ALLOCATION(synthetic).</P><P></P><P>The next rows are the sum(BALANCE) per DIVISION, for each month.</P><P></P><TABLE border="0" cellspacing="0" frame="void" rules="none"><TBODY><TR><TD align="left" height="20" style="border: #000000 1px solid;" width="121"><STRONG style="font-size: 12pt;">Division</STRONG></TD><TD align="left" style="border: #000000 1px solid;" width="67"><STRONG style="font-size: 12pt;">MONTH</STRONG></TD><TD align="right" style="border: #000000 1px solid;" width="67"><SPAN style="font-size: 12pt;">1</SPAN></TD><TD align="right" style="border: #000000 1px solid;" width="67"><SPAN style="font-size: 12pt;">2</SPAN></TD><TD align="right" style="border: #000000 1px solid;" width="67"><SPAN style="font-size: 12pt;">3</SPAN></TD><TD align="right" style="border: #000000 1px solid;" width="67"><SPAN style="font-size: 12pt;">4</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><STRONG style="font-size: 12pt;">ALLOCATION</STRONG></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;">0.4</TD><TD align="right" style="border: #000000 1px solid;">0.4</TD><TD align="right" style="border: #000000 1px solid;">0.4</TD><TD align="right" style="border: #000000 1px solid;">0.4</TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV1</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">600000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">160000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">750000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">1410000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV2</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">800000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">150000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">910000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">900000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV4</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">100000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">30000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">100000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">370000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV3</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">200000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">20000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">450000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">380000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV5</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">400000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">40000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">900000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">760000</SPAN></TD></TR><TR><TD align="left" height="20" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">DIV6</SPAN></TD><TD align="left" style="border: #000000 1px solid;"><BR /></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">200000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">20000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">450000</SPAN></TD><TD align="right" style="border: #000000 1px solid;"><SPAN style="font-size: 12pt;">380000</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P></P><P>sample dats is attached herewith.</P><P></P><P></P><P>Thanks,</P><P>Sonika </P></BODY></HTML> Thu, 03 May 2012 11:01:17 GMT https://community.qlik.com/t5/QlikView/adding-a-seperate-row-in-a-table/m-p/333877#M1177249 sonikajain 2012-05-03T11:01:17Z