title: Inner Join tables between a date range in QlikView
body: <p>How can I accomplish an inner join between two tables via a date field which ranges between two values in QlikView?</p>
  
  <p>In SQL this is possible with something like:</p>
  
  <pre><code>INNER JOIN TableA ON (TableA.Dates BETWEEN TableB.Start_Date AND TableB.End_Date)
  </code></pre>
  
  <p>In QlikView I have something like this: </p>
  
  <pre><code>DatesData:
  LOAD * Inline [  
  Test_Date 
      11/1/2013 
      12/1/2013  
      1/1/2014  
      2/1/2014  
      3/1/2014  
      4/1/2014  
      5/1/2014  
  ];
  
  PersonData:
  LOAD * Inline [  
  ID, Start_Date, End_Date
      1,   12/1/2013, 2/1/2014 
      2,   1/1/2013, 3/1/2014 
      3,   2/1/2014, 4/1/2014  
  ];
  </code></pre>
  
  <p>I need to create a table like this:</p>
  
  <pre><code> ID, Dates
   1, 12/1/2013  
   1, 1/1/2014  
   1, 2/1/2014 
   2, 1/1/2014 
   2, 2/1/2014
   2, 3/1/2014
   etc.....
  </code></pre>
  
  <p>How can I accomplish a join like this? </p>