topic Create rows - for each dimension in QlikView https://community.qlik.com/t5/QlikView/Create-rows-for-each-dimension/m-p/410604#M697390 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P></P><P>I have this 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>Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Min_YEAR</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Max_YEAR</STRONG></SPAN></TH></TR><TR><TD>ABC</TD><TD>2000</TD><TD>2002</TD></TR><TR><TD>CBA</TD><TD>1999</TD><TD>2001</TD></TR><TR><TD>BCA</TD><TD>2001</TD><TD>2002</TD></TR><TR><TD>BAC</TD><TD>1999</TD><TD>2002</TD></TR></TBODY></TABLE><P></P><P></P><P>And I need to create 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>Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>YEAR</STRONG></SPAN></TH></TR><TR><TD>ABC</TD><TD>2000</TD></TR><TR><TD>ABC</TD><TD>2001</TD></TR><TR><TD>ABC</TD><TD>2002</TD></TR><TR><TD>CBA</TD><TD>1999</TD></TR><TR><TD>CBA</TD><TD>2000</TD></TR><TR><TD>CBA</TD><TD>2001</TD></TR><TR><TD>BCA</TD><TD>2001</TD></TR><TR><TD>BCA</TD><TD>2002</TD></TR><TR><TD>BAC</TD><TD>1999</TD></TR><TR><TD>BAC</TD><TD>2000</TD></TR><TR><TD>BAC</TD><TD>2001</TD></TR><TR><TD>BAC</TD><TD>2002</TD></TR></TBODY></TABLE><P></P><P></P><P>I was trying to use for each, but it didn't worked.</P><P></P><P>Tks a lot !</P></BODY></HTML> Tue, 05 Mar 2013 19:10:10 GMT 2013-03-05T19:10:10Z Create rows - for each dimension https://community.qlik.com/t5/QlikView/Create-rows-for-each-dimension/m-p/410604#M697390 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P></P><P>I have this 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>Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Min_YEAR</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Max_YEAR</STRONG></SPAN></TH></TR><TR><TD>ABC</TD><TD>2000</TD><TD>2002</TD></TR><TR><TD>CBA</TD><TD>1999</TD><TD>2001</TD></TR><TR><TD>BCA</TD><TD>2001</TD><TD>2002</TD></TR><TR><TD>BAC</TD><TD>1999</TD><TD>2002</TD></TR></TBODY></TABLE><P></P><P></P><P>And I need to create 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>Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>YEAR</STRONG></SPAN></TH></TR><TR><TD>ABC</TD><TD>2000</TD></TR><TR><TD>ABC</TD><TD>2001</TD></TR><TR><TD>ABC</TD><TD>2002</TD></TR><TR><TD>CBA</TD><TD>1999</TD></TR><TR><TD>CBA</TD><TD>2000</TD></TR><TR><TD>CBA</TD><TD>2001</TD></TR><TR><TD>BCA</TD><TD>2001</TD></TR><TR><TD>BCA</TD><TD>2002</TD></TR><TR><TD>BAC</TD><TD>1999</TD></TR><TR><TD>BAC</TD><TD>2000</TD></TR><TR><TD>BAC</TD><TD>2001</TD></TR><TR><TD>BAC</TD><TD>2002</TD></TR></TBODY></TABLE><P></P><P></P><P>I was trying to use for each, but it didn't worked.</P><P></P><P>Tks a lot !</P></BODY></HTML> Tue, 05 Mar 2013 19:10:10 GMT https://community.qlik.com/t5/QlikView/Create-rows-for-each-dimension/m-p/410604#M697390 2013-03-05T19:10:10Z Re: Create rows - for each dimension https://community.qlik.com/t5/QlikView/Create-rows-for-each-dimension/m-p/410605#M697391 <HTML><HEAD></HEAD><BODY><P>See attached example</P></BODY></HTML> Tue, 05 Mar 2013 19:26:55 GMT https://community.qlik.com/t5/QlikView/Create-rows-for-each-dimension/m-p/410605#M697391 Gysbert_Wassenaar 2013-03-05T19:26:55Z