Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
bramvdpoel
Contributor III
Contributor III

Load Where Field < and >

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';

1 Solution

Accepted Solutions
uacg0009
Partner - Specialist
Partner - Specialist

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

View solution in original post

3 Replies
uacg0009
Partner - Specialist
Partner - Specialist

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
Contributor III
Contributor III
Author

Worked perfectly! Thanks a lot

uacg0009
Partner - Specialist
Partner - Specialist

You're welcome, glad to help you~