topic Re: Load Where Field < and > in QlikView

Load Where Field < and >

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

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

Re: Load Where Field < and >

uacg0009 — Fri, 14 Dec 2018 08:31:11 GMT

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

Re: Load Where Field < and >

bramvdpoel — Fri, 14 Dec 2018 12:09:05 GMT

Worked perfectly! Thanks a lot

Re: Load Where Field < and >

uacg0009 — Mon, 17 Dec 2018 01:56:51 GMT

You're welcome, glad to help you~