topic Date in Table A between two dates in Table B in QlikView

Date in Table A between two dates in Table B

Wed, 21 Sep 2011 14:33:37 GMT

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

SunilChauhan — Wed, 21 Sep 2011 14:37:47 GMT

hope interval match will help you

see the examle from help for interval match

Anonymous — Thu, 22 Sep 2011 07:12:43 GMT

No exactly what you asked for but take a look at the attached QV-files. Maybe it gives you a push in the right direction.

Good luck,

Dennis.