Load Where Field < and >

[bramvdpoel]

Hi,

I'm trying to load a field and want to exclude a range of values.  I only want to load values less then '07000' and greater then '09999'.

Or exclude 07000 till 09999. 

ART:

Directory;
LOAD Artid,
Akgid,
Date(Dtmaanmaak)
FROM
[G:\QlikviewDocuments\DATA\ODBCAGP\Jari_ART_Artikel.qvd]
(qvd)
Where Date(Dtmaanmaak) > '27-11-2018' and Akgid < '07000';

[uacg0009 · Accepted solution]

Hi Bramvdpoel,
Do you mean:

ART:

Directory;
LOAD Artid,
Akgid,
Date(Dtmaanmaak)
FROM
[G:\QlikviewDocuments\DATA\ODBCAGP\Jari_ART_Artikel.qvd]
(qvd)
Where Date(Dtmaanmaak) > '27-11-2018' and (Akgid < '07000' or Akgid > '09999');

Thanks.
Aiolos

[bramvdpoel]

Worked perfectly! Thanks a lot

[uacg0009]

You're welcome, glad to help you~