topic Re: Dynamic Table in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Table/m-p/450867#M560248 <HTML><HEAD></HEAD><BODY><P>Im adding 2 files, one with some sample data and an image with the expected results. Thanks for the help</P></BODY></HTML> Sun, 14 Apr 2013 16:27:30 GMT 2013-04-14T16:27:30Z Dynamic Table https://community.qlik.com/t5/QlikView/Dynamic-Table/m-p/450866#M560247 <HTML><HEAD></HEAD><BODY><P>Folks, please your help.</P><P></P><P>I'll have to create the following dynamic table</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="41.18181824684143" style="width: 686.1818182468414px; height: 42.18181824684143px;"><TBODY><TR><TD class="xl70" height="20" width="163">BRAND</TD><TD class="xl70" height="20" width="163">MODEL</TD><TD class="xl65" width="75">MTD</TD><TD class="xl66" style="border-left: none;" width="75">% </TD><TD class="xl66" style="border-left: none;" width="75">SHARE</TD><TD class="xl66" style="border-left: none;" width="75">VAR. m-1</TD><TD class="xl67" style="border-left: none;" width="75">VAR. m-12</TD></TR><TR><TD class="xl71" height="20" style="border-top: none;">&nbsp;&nbsp;&nbsp; </TD><TD class="xl71" height="20" style="border-top: none;"><BR /></TD><TD class="xl68" style="border-top: none;"> </TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD><TD class="xl69" style="border-top: none; border-left: none;"> </TD><TD class="xl72" style="border-top: none; border-left: none;"> </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>Brand: Group of brands</P><P></P><P>Model: List of each model within the Brand group (User can expand or collapse)</P><P></P><P>MTD: Number of registers (month to date) - Count in current month</P><P></P><P>% : The percentage that each model represent in the group ( Model / Group Total)</P><P></P><P>Share: The percentage that each model represent within the total (brands and models)</P><P></P><P>Could Anyone please help me ? How can I calculate this ?</P></BODY></HTML> Fri, 12 Apr 2013 20:28:33 GMT https://community.qlik.com/t5/QlikView/Dynamic-Table/m-p/450866#M560247 2013-04-12T20:28:33Z Re: Dynamic Table https://community.qlik.com/t5/QlikView/Dynamic-Table/m-p/450867#M560248 <HTML><HEAD></HEAD><BODY><P>Im adding 2 files, one with some sample data and an image with the expected results. Thanks for the help</P></BODY></HTML> Sun, 14 Apr 2013 16:27:30 GMT https://community.qlik.com/t5/QlikView/Dynamic-Table/m-p/450867#M560248 2013-04-14T16:27:30Z