topic Generating dynamic rows in QlikView

topic Generating dynamic rows in QlikView https://community.qlik.com/t5/QlikView/Generating-dynamic-rows/m-p/458175#M171045 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am stuck with a requirement.basically i have one variable which consist of Month values. Now whatever value for this variable comes ,in table that many rows for month column should appear.</P><P>Eg .  if </P><P>Var_month = 9</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 300px;"><TBODY><TR><TD class="xl64" height="60" width="64"><SPAN style="color: #3366ff;">Month</SPAN></TD><TD class="xl64" style="border-left: medium none;" width="64">Plan Monthly</TD><TD class="xl64" style="border-left: medium none;" width="64">Run rate / </TD><TD class="xl64" style="border-left: medium none;" width="108">Actual spend </TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">7000</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">12000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">10500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">20000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">4</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">14000</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">25000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">17500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">33000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">21000</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">7</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">24500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">45000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">28000</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">50000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">9</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">31500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">52000</TD></TR></TBODY></TABLE><P></P><P></P><P>Any suggestions folks ?</P><P></P><P>Thanks,</P><P>AA</P></BODY></HTML> Tue, 14 May 2013 13:18:14 GMT 2013-05-14T13:18:14Z Generating dynamic rows https://community.qlik.com/t5/QlikView/Generating-dynamic-rows/m-p/458175#M171045 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am stuck with a requirement.basically i have one variable which consist of Month values. Now whatever value for this variable comes ,in table that many rows for month column should appear.</P><P>Eg .  if </P><P>Var_month = 9</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 300px;"><TBODY><TR><TD class="xl64" height="60" width="64"><SPAN style="color: #3366ff;">Month</SPAN></TD><TD class="xl64" style="border-left: medium none;" width="64">Plan Monthly</TD><TD class="xl64" style="border-left: medium none;" width="64">Run rate / </TD><TD class="xl64" style="border-left: medium none;" width="108">Actual spend </TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">7000</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">12000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">10500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">20000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">4</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">14000</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">25000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">17500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">33000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">21000</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">7</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">24500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">45000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">28000</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">50000</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">9</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3500</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">31500</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">52000</TD></TR></TBODY></TABLE><P></P><P></P><P>Any suggestions folks ?</P><P></P><P>Thanks,</P><P>AA</P></BODY></HTML> Tue, 14 May 2013 13:18:14 GMT https://community.qlik.com/t5/QlikView/Generating-dynamic-rows/m-p/458175#M171045 2013-05-14T13:18:14Z