topic Re: autogenerate?? in QlikView https://community.qlik.com/t5/QlikView/autogenerate/m-p/421610#M157035 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Miguel!</P><P></P><P>This is exactly what I search for!</P></BODY></HTML> Wed, 19 Sep 2012 12:13:27 GMT wunderch 2012-09-19T12:13:27Z autogenerate?? https://community.qlik.com/t5/QlikView/autogenerate/m-p/421608#M157033 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have the following problem:</P><P>I have a table like this</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>from Month<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>from Year<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>until Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>until Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Budget <BR /></TH></TR><TR><TD>09</TD><TD>2012</TD><TD>12</TD><TD>2012</TD><TD>5%</TD></TR></TBODY></TABLE><P></P><P>Now I want to create a table like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Budget</STRONG></SPAN></TH></TR><TR><TD>09</TD><TD>2012</TD><TD>5%</TD></TR><TR><TD>10</TD><TD>2012</TD><TD>5%</TD></TR><TR><TD>11</TD><TD>2012</TD><TD>5%</TD></TR><TR><TD>12</TD><TD>2012</TD><TD>5%</TD></TR></TBODY></TABLE><P></P><P>Any Ideas???????</P><P></P><P>Thanks for regards</P><P></P><P>Christian</P></BODY></HTML> Wed, 19 Sep 2012 11:49:29 GMT https://community.qlik.com/t5/QlikView/autogenerate/m-p/421608#M157033 wunderch 2012-09-19T11:49:29Z Re: autogenerate?? https://community.qlik.com/t5/QlikView/autogenerate/m-p/421609#M157034 <HTML><HEAD></HEAD><BODY><P>Hi Christian,</P><P></P><P>Use the <A _jive_internal="true" href="https://community.qlik.com/thread/53577?start=0&amp;tstart=0">code in this post</A>, that uses IntervalMatch() LOAD to solve the issue.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Wed, 19 Sep 2012 11:56:35 GMT https://community.qlik.com/t5/QlikView/autogenerate/m-p/421609#M157034 Miguel_Angel_Baeyens 2012-09-19T11:56:35Z Re: autogenerate?? https://community.qlik.com/t5/QlikView/autogenerate/m-p/421610#M157035 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Miguel!</P><P></P><P>This is exactly what I search for!</P></BODY></HTML> Wed, 19 Sep 2012 12:13:27 GMT https://community.qlik.com/t5/QlikView/autogenerate/m-p/421610#M157035 wunderch 2012-09-19T12:13:27Z