topic Re: Repeating number of Rows in QlikView

topic Re: Repeating number of Rows in QlikView https://community.qlik.com/t5/QlikView/Repeating-number-of-Rows/m-p/388405#M696981 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>Result:</P><P>load DimensionCode, To, From, To + iterno() -1 as Range</P><P>from ...somewhere...</P><P>while To + iterno() -1 <= From;</P><DIV> </DIV></BODY></HTML> Mon, 25 Mar 2013 13:52:17 GMT Gysbert_Wassenaar 2013-03-25T13:52:17Z Repeating number of Rows https://community.qlik.com/t5/QlikView/Repeating-number-of-Rows/m-p/388404#M696980 <HTML><HEAD></HEAD><BODY><P>Hi Guys </P><P>I have a table as Follows:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="235"><TBODY><TR><TD height="20" width="107">DimensionCode</TD><TD width="64">To</TD><TD width="64">From</TD></TR><TR><TD height="20">1A</TD><TD align="right">1</TD><TD align="right">3</TD></TR><TR><TD height="20">1B</TD><TD align="right">6</TD><TD align="right">8</TD></TR></TBODY></TABLE><P></P><P>and i want the output as </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="299"><TBODY><TR><TD height="20" width="107">DimensionCode</TD><TD width="64">To</TD><TD width="64">From</TD><TD width="64">Range</TD></TR><TR><TD height="20">1A</TD><TD align="right">1</TD><TD align="right">3</TD><TD align="right">1</TD></TR><TR><TD height="20">1A</TD><TD align="right">1</TD><TD align="right">3</TD><TD align="right">2</TD></TR><TR><TD height="20">1A</TD><TD align="right">1</TD><TD align="right">3</TD><TD align="right">3</TD></TR><TR><TD height="20">1B</TD><TD align="right">6</TD><TD align="right">8</TD><TD align="right">6</TD></TR><TR><TD height="20">1B</TD><TD align="right">6</TD><TD align="right">8</TD><TD align="right">7</TD></TR><TR><TD height="20">1B</TD><TD align="right">6</TD><TD align="right">8</TD><TD align="right">8</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 25 Mar 2013 13:50:00 GMT https://community.qlik.com/t5/QlikView/Repeating-number-of-Rows/m-p/388404#M696980 2013-03-25T13:50:00Z Re: Repeating number of Rows https://community.qlik.com/t5/QlikView/Repeating-number-of-Rows/m-p/388405#M696981 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>Result:</P><P>load DimensionCode, To, From, To + iterno() -1 as Range</P><P>from ...somewhere...</P><P>while To + iterno() -1 <= From;</P><DIV> </DIV></BODY></HTML> Mon, 25 Mar 2013 13:52:17 GMT https://community.qlik.com/t5/QlikView/Repeating-number-of-Rows/m-p/388405#M696981 Gysbert_Wassenaar 2013-03-25T13:52:17Z