topic Vertical Table in QlikView

topic Vertical Table in QlikView https://community.qlik.com/t5/QlikView/Vertical-Table/m-p/522657#M195271 <HTML><HEAD></HEAD><BODY><P>I am here again with another problem. I have this data in an Excel File:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="299" style="width: 403px; height: 299px;"><TBODY><TR><TD class="xl64" height="20" width="162"><STRONG>Title 1</STRONG></TD><TD class="xl64" width="80"><STRONG>Title 2</STRONG></TD><TD class="xl64" width="80"><STRONG>Title 3</STRONG></TD><TD align="right" class="xl65" width="80"><STRONG>jun-13</STRONG></TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500001</TD><TD align="right">820724835</TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500006</TD><TD align="right">654480574</TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500012</TD><TD align="right">45696827</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500002</TD><TD align="right">80371512</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500003</TD><TD align="right">118080930</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500013</TD><TD align="right">9463308</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500007</TD><TD align="right">222962791</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500014</TD><TD align="right">54330714</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500015</TD><TD align="right">12911312</TD></TR><TR><TD height="20">Derivable</TD><TD align="right">1021080</TD><TD align="right">5235500008</TD><TD align="right">189631760</TD></TR><TR><TD height="20">Devolutions</TD><TD align="right">1021080</TD><TD align="right">5235500004</TD><TD align="right">10313974</TD></TR></TBODY></TABLE><P></P><P>And I need to create a report with this structure and subtotals:</P><TABLE border="0" cellpadding="0" cellspacing="0" height="449" style="width: 425px; height: 449px;"><TBODY><TR><TD class="xl66" height="20" width="117">Ti<STRONG>tle 1</STRONG></TD><TD class="xl66" width="56"><STRONG>Title 2</STRONG></TD><TD class="xl66" width="77"><STRONG>Title 3</STRONG></TD><TD align="right" class="xl67" width="99"><STRONG>jun-13</STRONG></TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500001</TD><TD class="xl68">      820.724.835</TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500006</TD><TD class="xl68">      654.480.574</TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500012</TD><TD class="xl68">         45.696.827</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total Primary</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><SPAN style="color: #ff0000;"><STRONG>   1.520.902.236</STRONG> </SPAN></TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500002</TD><TD class="xl68">         80.371.512</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500003</TD><TD class="xl68">      118.080.930</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500013</TD><TD class="xl68">           9.463.308</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total Secundary</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><SPAN style="color: #ff0000;"><STRONG>      207.915.750 </STRONG></SPAN></TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500007</TD><TD class="xl68">      222.962.791</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500014</TD><TD class="xl68">         54.330.714</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500015</TD><TD class="xl68">         12.911.312</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total TAT</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><SPAN style="color: #ff0000;"><STRONG>      290.204.817</STRONG> </SPAN></TD></TR><TR><TD height="20">Derivable</TD><TD align="right">1021080</TD><TD align="right">5235500008</TD><TD class="xl68">      189.631.760</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total Derivable</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><STRONG><SPAN style="color: #ff0000;">      189.631.760</SPAN> </STRONG></TD></TR><TR><TD height="20">Devolutions</TD><TD align="right">1021080</TD><TD align="right">5235500004</TD><TD class="xl68">         10.313.974</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total Devolutions</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><SPAN style="color: #ff0000;"><STRONG>         10.313.974 </STRONG></SPAN></TD></TR><TR><TD class="xl71" height="20"><SPAN style="color: #0000ff;"><STRONG>TOTAL</STRONG></SPAN></TD><TD class="xl71"></TD><TD class="xl71"></TD><TD class="xl72"><SPAN style="color: #0000ff;"><STRONG>   2.218.968.537</STRONG></SPAN></TD></TR></TBODY></TABLE><P></P><P>Thanks.</P></BODY></HTML> Thu, 24 Oct 2013 17:25:57 GMT 2013-10-24T17:25:57Z Vertical Table https://community.qlik.com/t5/QlikView/Vertical-Table/m-p/522657#M195271 <HTML><HEAD></HEAD><BODY><P>I am here again with another problem. I have this data in an Excel File:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="299" style="width: 403px; height: 299px;"><TBODY><TR><TD class="xl64" height="20" width="162"><STRONG>Title 1</STRONG></TD><TD class="xl64" width="80"><STRONG>Title 2</STRONG></TD><TD class="xl64" width="80"><STRONG>Title 3</STRONG></TD><TD align="right" class="xl65" width="80"><STRONG>jun-13</STRONG></TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500001</TD><TD align="right">820724835</TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500006</TD><TD align="right">654480574</TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500012</TD><TD align="right">45696827</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500002</TD><TD align="right">80371512</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500003</TD><TD align="right">118080930</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500013</TD><TD align="right">9463308</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500007</TD><TD align="right">222962791</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500014</TD><TD align="right">54330714</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500015</TD><TD align="right">12911312</TD></TR><TR><TD height="20">Derivable</TD><TD align="right">1021080</TD><TD align="right">5235500008</TD><TD align="right">189631760</TD></TR><TR><TD height="20">Devolutions</TD><TD align="right">1021080</TD><TD align="right">5235500004</TD><TD align="right">10313974</TD></TR></TBODY></TABLE><P></P><P>And I need to create a report with this structure and subtotals:</P><TABLE border="0" cellpadding="0" cellspacing="0" height="449" style="width: 425px; height: 449px;"><TBODY><TR><TD class="xl66" height="20" width="117">Ti<STRONG>tle 1</STRONG></TD><TD class="xl66" width="56"><STRONG>Title 2</STRONG></TD><TD class="xl66" width="77"><STRONG>Title 3</STRONG></TD><TD align="right" class="xl67" width="99"><STRONG>jun-13</STRONG></TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500001</TD><TD class="xl68">      820.724.835</TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500006</TD><TD class="xl68">      654.480.574</TD></TR><TR><TD height="20">Primary</TD><TD align="right">1021080</TD><TD align="right">5235500012</TD><TD class="xl68">         45.696.827</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total Primary</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><SPAN style="color: #ff0000;"><STRONG>   1.520.902.236</STRONG> </SPAN></TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500002</TD><TD class="xl68">         80.371.512</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500003</TD><TD class="xl68">      118.080.930</TD></TR><TR><TD height="20">Secundary</TD><TD align="right">1021080</TD><TD align="right">5235500013</TD><TD class="xl68">           9.463.308</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total Secundary</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><SPAN style="color: #ff0000;"><STRONG>      207.915.750 </STRONG></SPAN></TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500007</TD><TD class="xl68">      222.962.791</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500014</TD><TD class="xl68">         54.330.714</TD></TR><TR><TD height="20">TAT</TD><TD align="right">1021080</TD><TD align="right">5235500015</TD><TD class="xl68">         12.911.312</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total TAT</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><SPAN style="color: #ff0000;"><STRONG>      290.204.817</STRONG> </SPAN></TD></TR><TR><TD height="20">Derivable</TD><TD align="right">1021080</TD><TD align="right">5235500008</TD><TD class="xl68">      189.631.760</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total Derivable</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><STRONG><SPAN style="color: #ff0000;">      189.631.760</SPAN> </STRONG></TD></TR><TR><TD height="20">Devolutions</TD><TD align="right">1021080</TD><TD align="right">5235500004</TD><TD class="xl68">         10.313.974</TD></TR><TR><TD class="xl69" height="20"><SPAN style="color: #ff0000;"><STRONG>Total Devolutions</STRONG></SPAN></TD><TD class="xl69"></TD><TD class="xl69"></TD><TD class="xl70"><SPAN style="color: #ff0000;"><STRONG>         10.313.974 </STRONG></SPAN></TD></TR><TR><TD class="xl71" height="20"><SPAN style="color: #0000ff;"><STRONG>TOTAL</STRONG></SPAN></TD><TD class="xl71"></TD><TD class="xl71"></TD><TD class="xl72"><SPAN style="color: #0000ff;"><STRONG>   2.218.968.537</STRONG></SPAN></TD></TR></TBODY></TABLE><P></P><P>Thanks.</P></BODY></HTML> Thu, 24 Oct 2013 17:25:57 GMT https://community.qlik.com/t5/QlikView/Vertical-Table/m-p/522657#M195271 2013-10-24T17:25:57Z Re: Vertical Table https://community.qlik.com/t5/QlikView/Vertical-Table/m-p/522658#M195272 <HTML><HEAD></HEAD><BODY><P>The resulting structure is not quite the same but you could try a pivot table and apply partial sums at Title1/Title2 level:</P><P></P><P><IMG __jive_id="48129" alt="x2013-10-24_18h42_44.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/48129_x2013-10-24_18h42_44.png" /></P><P></P><P><IMG __jive_id="48128" alt="2013-10-24_18h39_23.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/48128_2013-10-24_18h39_23.png" style="width: 620px; height: 544px;" /></P><P></P><P>You could put a formula in "Label for Totals" above to apply custom labels.</P><P></P><P>In the above example Title1, Title2 and Title3 are dimensions, and column "Sum" is the expression sum([jun-13])</P></BODY></HTML> Thu, 24 Oct 2013 17:44:20 GMT https://community.qlik.com/t5/QlikView/Vertical-Table/m-p/522658#M195272 2013-10-24T17:44:20Z Re: Vertical Table https://community.qlik.com/t5/QlikView/Vertical-Table/m-p/522659#M195273 <HTML><HEAD></HEAD><BODY><P>Thanks Kai !!</P></BODY></HTML> Fri, 25 Oct 2013 16:19:26 GMT https://community.qlik.com/t5/QlikView/Vertical-Table/m-p/522659#M195273 2013-10-25T16:19:26Z