topic New Table Btwn 2 Fields in QlikView https://community.qlik.com/t5/QlikView/New-Table-Btwn-2-Fields/m-p/236803#M87943 <HTML><HEAD></HEAD><BODY><P>Sorry, just found the answer</P><P>Date:<BR />LOAD<BR /> date1,<BR /> date2,<BR /> id,<BR /> date(date1 + iterno()-1) as DateLink<BR />RESIDENT table1<BR />WHILE date1 + iterno()-1 &lt;= date2;</P></BODY></HTML> Wed, 13 Oct 2010 20:49:37 GMT 2010-10-13T20:49:37Z New Table Btwn 2 Fields https://community.qlik.com/t5/QlikView/New-Table-Btwn-2-Fields/m-p/236802#M87942 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P>I have a table with id, date1 and date2.</P><P>I want to be able to create a new table with records inbtwn the dates.</P><P>So record</P><P>1, 1/1/2010, 1/3/2010</P><P>Would result in</P><P>1, 1/1/2010<BR />1. 1/2/2010<BR />1, 1/3/2010</P><P>Any ideas on how I can do it?</P></BODY></HTML> Wed, 13 Oct 2010 20:26:10 GMT https://community.qlik.com/t5/QlikView/New-Table-Btwn-2-Fields/m-p/236802#M87942 2010-10-13T20:26:10Z New Table Btwn 2 Fields https://community.qlik.com/t5/QlikView/New-Table-Btwn-2-Fields/m-p/236803#M87943 <HTML><HEAD></HEAD><BODY><P>Sorry, just found the answer</P><P>Date:<BR />LOAD<BR /> date1,<BR /> date2,<BR /> id,<BR /> date(date1 + iterno()-1) as DateLink<BR />RESIDENT table1<BR />WHILE date1 + iterno()-1 &lt;= date2;</P></BODY></HTML> Wed, 13 Oct 2010 20:49:37 GMT https://community.qlik.com/t5/QlikView/New-Table-Btwn-2-Fields/m-p/236803#M87943 2010-10-13T20:49:37Z