Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
william_denholm
New Contributor III

Load Where Field = Field

I have data set as below

Ref NoDate EnteredDate Req
101/01/201601/01/2016
210/10/201611/10/2016
321/02/201616/05/2016

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])));




1 Reply

Re: Load Where Field = Field

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

Get the Dates Right

Why don’t my dates work?