Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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~