2 Replies Latest reply: Sep 22, 2011 3:12 AM by Dennis Hoogenboom RSS

    Date in Table A between two dates in Table B

      Hi,

       

      I'm new to QlikView and what i'm trying to do is propbably very easy for those who have been working with this for a long time.

       

      I have one table, let's call it A with one date field:

       

      Date

      15-09-2011

      16-09-2011

      .

      .

      .

      21-09-2011

       

      And I have table B with first date and last date:

       

      FirstDate          LastDate

      01-01-2011       08-01-2011

      .                      .

      .                      .

      .                      .

      14-09-2011       21-09-2011

       

      Now, I wanna link table A to table B if the date from table A is between (or equal) to the date interval in table B.

       

      Is it possible? How? 

       

      Thanks