How to join Resident tables by where clause

[dijkstram]

HI,

I'm not yet that familiar with Qlikview, I have searched the forum but didnot found the solution.

I want to load two Resident tables into one table dependent on a Where Clause. The Date of the first table is between the START DATE and END DATE of the second resident table. How to fix it. The Date column of the first table is not recognized. in the Where clause.

TabA:

LOAD

Key, Date

Resident A;

Inner Join(TabA)

LOAD

Key, STARTDATE, ENDDATE

Resident B

WHERE Date between STARTDATE AND ENDDATE;

Hope to hear soon from the experts.

Kind regards

[prieper]

Have a look into the INTERVALMATCH()-function

HTH
Peter

[dijkstram]

How to deal with the intervalmatch, from table A and the second table I have to load different columns, do you have an example

[prieper]

Please find a sample in the attachment

HTH

[#5]

Hi,

When you joined tables "A" and "B", will be create a new table.

You need put your filter in the new table.

Ex.:

TableA:

...

TableB:

Inner Join (TableA)

....

NOCONCATENATE

(this is a new table whith data values from TableA and TableB)

TableA:

Load...

From...

Where Date >= STARTDATE

and Date <= ENDDATE;

[dijkstram]

Thanks a lot, it was helpful