topic Dynamic tables in QlikView https://community.qlik.com/t5/QlikView/Dynamic-tables/m-p/515527#M192500 <HTML><HEAD></HEAD><BODY><P>HI Guys,</P><P>I am new to qlikview and i want to create filters on the left like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD class="xl69" colspan="2" height="22" width="128">Report Month</TD><TD class="xl63" width="64"> </TD><TD class="xl63" width="64"> </TD></TR><TR><TD align="right" class="xl64" height="20">Jan-12</TD><TD align="right" class="xl64" style="border-left: none;">Jul-12</TD><TD align="right" class="xl64" style="border-left: none;">Jan-13</TD><TD align="right" class="xl66" style="border-left: none;">Jul-13</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">Feb-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Aug-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Feb-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">Mar-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Sep-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Mar-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD align="right" class="xl64" height="21" style="border-top: none;">Apr-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Oct-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Apr-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">May-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Nov-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">May-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD align="right" class="xl64" height="21" style="border-top: none;">Jun-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Dec-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Jun-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl69" height="24">Day</TD><TD class="xl63"> </TD><TD class="xl63"> </TD><TD class="xl63"> </TD></TR><TR><TD align="right" class="xl68" height="20">1</TD><TD align="right" class="xl67" style="border-left: none;">9</TD><TD align="right" class="xl67" style="border-left: none;">17</TD><TD align="right" class="xl67" style="border-left: none;">25</TD></TR><TR><TD align="right" class="xl68" height="22" style="border-top: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">18</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">26</TD></TR><TR><TD align="right" class="xl68" height="21" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">11</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">27</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">28</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">21</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">29</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">22</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">23</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">31</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">24</TD><TD class="xl70" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl69" colspan="3" height="24">Team</TD><TD class="xl63"> </TD></TR><TR><TD class="xl75" colspan="2" height="20" style="border-right: .5pt solid black;">Customer Service</TD><TD class="xl71" colspan="2" style="border-right: .5pt solid black; border-left: none;">Service Assurance</TD></TR><TR><TD class="xl75" colspan="2" height="20" style="border-right: .5pt solid black;">Customer Specialist</TD><TD class="xl71" colspan="2" style="border-right: .5pt solid black; border-left: none;">LRU</TD></TR><TR><TD class="xl71" colspan="2" height="20" style="border-right: .5pt solid black;">Licensed CSR</TD><TD class="xl71" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl71" colspan="2" height="20" style="border-right: .5pt solid black;">Rate Pursuit</TD><TD class="xl73" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>The main table would be something like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 970px;"><TBODY><TR><TD class="xl67" height="20" width="64"><SPAN style="color: #ff0000;">Customer Service</SPAN></TD><TD class="xl68" width="128"> </TD><TD class="xl68" width="64"> </TD><TD class="xl68" width="93"> </TD></TR><TR><TD class="xl73" colspan="2" height="20" style="border-right: .5pt solid black;">Metric</TD><TD class="xl71" colspan="2" style="border-left: none;"><SPAN style="color: #ffcc00;">Monday, July 1, 2013</SPAN></TD><TD class="xl71" colspan="2" style="border-left: none;"><SPAN style="color: #ffcc00;">Tuesday, July 2, 2013</SPAN></TD><TD class="xl71" colspan="2" style="border-right: 1.0pt solid black; border-left: none;"><SPAN style="color: #ffcc00;">Wednesday, July 3, 2013</SPAN></TD><TD class="xl78" colspan="2" style="border-right: .5pt solid black; border-left: none;">July MTD</TD><TD class="xl67" colspan="2" style="border-right: .5pt solid black; border-left: none;">Standard</TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Abandon Rate</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none;"> </TD><TD class="xl67" colspan="2" style="border-right: .5pt solid black; border-left: none;">5-7%</TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Service Level</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none;"> </TD><TD class="xl67" colspan="2" style="border-right: .5pt solid black; border-left: none;">0.8</TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">ASA</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none;"> </TD><TD class="xl67" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="24" style="border-right: .5pt solid black;">Talk Time</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Wrap Time</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">AHT</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Available %</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Actual Volume</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Forecasted Volume</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">% O/U Forecast</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Run Rate</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Plan Volume</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">% O/U Plan</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Emails in Queue</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Within 18 Hours</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl75" colspan="2" style="border-right: .5pt solid black; border-left: none;">95.00%</TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl75" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Absenteeism</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Adherence</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">VTO</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="12" height="20" style="border-right: .5pt solid black;"> </TD></TR></TBODY></TABLE><P></P><P>Red denotes team name, orange the value of a metric say day. The rest are all metrics.</P><P></P><P>My question is how can you align the metrics in positions like shown above.</P><P>My second question is i want to do something like: if i select 2 teams then i get 2 different tables. if i select 1, i get only 1 main table.</P><P></P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks,</P><P>Eshan</P></BODY></HTML> Tue, 23 Jul 2013 21:26:47 GMT 2013-07-23T21:26:47Z Dynamic tables https://community.qlik.com/t5/QlikView/Dynamic-tables/m-p/515527#M192500 <HTML><HEAD></HEAD><BODY><P>HI Guys,</P><P>I am new to qlikview and i want to create filters on the left like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD class="xl69" colspan="2" height="22" width="128">Report Month</TD><TD class="xl63" width="64"> </TD><TD class="xl63" width="64"> </TD></TR><TR><TD align="right" class="xl64" height="20">Jan-12</TD><TD align="right" class="xl64" style="border-left: none;">Jul-12</TD><TD align="right" class="xl64" style="border-left: none;">Jan-13</TD><TD align="right" class="xl66" style="border-left: none;">Jul-13</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">Feb-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Aug-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Feb-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">Mar-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Sep-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Mar-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD align="right" class="xl64" height="21" style="border-top: none;">Apr-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Oct-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Apr-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">May-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Nov-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">May-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD align="right" class="xl64" height="21" style="border-top: none;">Jun-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Dec-12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Jun-13</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl69" height="24">Day</TD><TD class="xl63"> </TD><TD class="xl63"> </TD><TD class="xl63"> </TD></TR><TR><TD align="right" class="xl68" height="20">1</TD><TD align="right" class="xl67" style="border-left: none;">9</TD><TD align="right" class="xl67" style="border-left: none;">17</TD><TD align="right" class="xl67" style="border-left: none;">25</TD></TR><TR><TD align="right" class="xl68" height="22" style="border-top: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">18</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">26</TD></TR><TR><TD align="right" class="xl68" height="21" style="border-top: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">11</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">27</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">28</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">21</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">29</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">22</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">23</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">31</TD></TR><TR><TD align="right" class="xl67" height="20" style="border-top: none;">8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">24</TD><TD class="xl70" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl69" colspan="3" height="24">Team</TD><TD class="xl63"> </TD></TR><TR><TD class="xl75" colspan="2" height="20" style="border-right: .5pt solid black;">Customer Service</TD><TD class="xl71" colspan="2" style="border-right: .5pt solid black; border-left: none;">Service Assurance</TD></TR><TR><TD class="xl75" colspan="2" height="20" style="border-right: .5pt solid black;">Customer Specialist</TD><TD class="xl71" colspan="2" style="border-right: .5pt solid black; border-left: none;">LRU</TD></TR><TR><TD class="xl71" colspan="2" height="20" style="border-right: .5pt solid black;">Licensed CSR</TD><TD class="xl71" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl71" colspan="2" height="20" style="border-right: .5pt solid black;">Rate Pursuit</TD><TD class="xl73" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>The main table would be something like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 970px;"><TBODY><TR><TD class="xl67" height="20" width="64"><SPAN style="color: #ff0000;">Customer Service</SPAN></TD><TD class="xl68" width="128"> </TD><TD class="xl68" width="64"> </TD><TD class="xl68" width="93"> </TD></TR><TR><TD class="xl73" colspan="2" height="20" style="border-right: .5pt solid black;">Metric</TD><TD class="xl71" colspan="2" style="border-left: none;"><SPAN style="color: #ffcc00;">Monday, July 1, 2013</SPAN></TD><TD class="xl71" colspan="2" style="border-left: none;"><SPAN style="color: #ffcc00;">Tuesday, July 2, 2013</SPAN></TD><TD class="xl71" colspan="2" style="border-right: 1.0pt solid black; border-left: none;"><SPAN style="color: #ffcc00;">Wednesday, July 3, 2013</SPAN></TD><TD class="xl78" colspan="2" style="border-right: .5pt solid black; border-left: none;">July MTD</TD><TD class="xl67" colspan="2" style="border-right: .5pt solid black; border-left: none;">Standard</TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Abandon Rate</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none;"> </TD><TD class="xl67" colspan="2" style="border-right: .5pt solid black; border-left: none;">5-7%</TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Service Level</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none;"> </TD><TD class="xl67" colspan="2" style="border-right: .5pt solid black; border-left: none;">0.8</TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">ASA</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl67" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none;"> </TD><TD class="xl67" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="24" style="border-right: .5pt solid black;">Talk Time</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Wrap Time</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">AHT</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Available %</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Actual Volume</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Forecasted Volume</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">% O/U Forecast</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Run Rate</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Plan Volume</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">% O/U Plan</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Emails in Queue</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Within 18 Hours</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl75" colspan="2" style="border-right: .5pt solid black; border-left: none;">95.00%</TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl75" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Absenteeism</TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">Adherence</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD></TR><TR><TD class="xl65" colspan="2" height="20" style="border-right: .5pt solid black;">VTO</TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD><TD class="xl65" colspan="2" style="border-right: .5pt solid black; border-left: none;"> </TD></TR><TR><TD class="xl65" colspan="12" height="20" style="border-right: .5pt solid black;"> </TD></TR></TBODY></TABLE><P></P><P>Red denotes team name, orange the value of a metric say day. The rest are all metrics.</P><P></P><P>My question is how can you align the metrics in positions like shown above.</P><P>My second question is i want to do something like: if i select 2 teams then i get 2 different tables. if i select 1, i get only 1 main table.</P><P></P><P></P><P>Any help would be appreciated.</P><P></P><P>Thanks,</P><P>Eshan</P></BODY></HTML> Tue, 23 Jul 2013 21:26:47 GMT https://community.qlik.com/t5/QlikView/Dynamic-tables/m-p/515527#M192500 2013-07-23T21:26:47Z