topic Populate Table (Date Range) in QlikView https://community.qlik.com/t5/QlikView/Populate-Table-Date-Range/m-p/441991#M164780 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Please help:</P><P></P><P>I have this table:</P><P></P><P>Starting Date&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; Exchange Rate</P><P>01/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>05/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>14/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.25</P><P></P><P>Can you suggest an efficient way to populate this so that I will have the following table:</P><P></P><P>Starting Date&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; Exchange Rate</P><P>01/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>02/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>03/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>04/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>05/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>06/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>07/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>08/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>09/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>10/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>11/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>12/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>13/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>14/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.25</P><P>...</P><P></P><P>Regards,</P><P></P><P>~skip</P></BODY></HTML> Wed, 26 Sep 2012 09:13:28 GMT 2012-09-26T09:13:28Z Populate Table (Date Range) https://community.qlik.com/t5/QlikView/Populate-Table-Date-Range/m-p/441991#M164780 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Please help:</P><P></P><P>I have this table:</P><P></P><P>Starting Date&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; Exchange Rate</P><P>01/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>05/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>14/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.25</P><P></P><P>Can you suggest an efficient way to populate this so that I will have the following table:</P><P></P><P>Starting Date&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; Exchange Rate</P><P>01/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>02/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>03/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>04/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.10</P><P>05/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>06/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>07/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>08/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>09/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>10/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>11/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>12/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>13/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.20</P><P>14/01/2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 1.25</P><P>...</P><P></P><P>Regards,</P><P></P><P>~skip</P></BODY></HTML> Wed, 26 Sep 2012 09:13:28 GMT https://community.qlik.com/t5/QlikView/Populate-Table-Date-Range/m-p/441991#M164780 2012-09-26T09:13:28Z