Load Where Field = Field

william_denholm — Wed, 25 Nov 2020 16:16:04 GMT

I have data set as below

I have this data in a temp table and want to do a resident load where the date entered is the same as the date req or is the day before the date req.

I've tried the below but it's not showing anything. Suggestions welcome

LOAD [Ref No],

[Date Entered],

[Date Req]

Resident Temp1

WHERE ((DATE([Date Entered]) = DATE([Date Req]) or ((DATE([Date Entered]+1) = DATE([Date Req])));

Re: Load Where Field = Field

sunny_talwar — Tue, 13 Sep 2016 15:49:18 GMT

May be like this:

TableNew:

NoConcatenate

LOAD [Ref No],

[Date Entered],

[Date Req]

Resident Temp1

WHERE [Date Entered]) = [Date Req] or [Date Entered]+1 = [Date Req];

Just make sure that dates are read correctly by QlikView and also dates are just dates and not timestamps