in between dates from 2 tables

himabinduch — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

i have one date filed in Table A and two date files in table B like below

Table A:

ITEM_ID , Price_date ,Qty

1,12-02-2019,10

2,12-03-2019,20

Table B:

ITEM_ID,Start_date,End-Date,list-NAME

2,14-02-2019,15-02-2019,TEST

2,1-01-2019,7-01-2019,TEST COMPLETED

now i need to pull the Table B data to Table A base on the price date if the price date fall between start date and end date then i need to pull that record example i should display start date of ITEm_ID 2 is 4-02-2019 and 15-02-2019 though they have two start dates and end dates in the second table.

Thanks

Hima Bindu Ch

Re: in between dates from 2 tables

Kushal_Chawda — Tue, 17 Dec 2019 15:28:37 GMT

Date in Table 2 for Item id 2 not falling in any of date range in table b.

topic in between dates from 2 tables in QlikView

in between dates from 2 tables

Re: in between dates from 2 tables