Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
aaronnayan
Contributor III

HELP excluding a certain value from a field

HI in the script

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) AND (DSDENAME<>'CLOSED'

1. There is a value in the DSDENAME field column called CLOSED that i do not want to include into the script. Can anyone help me with this please?

1 Solution

Accepted Solutions
adamdavi3s
Honored Contributor

Re: HELP excluding a certain value from a field

This should work?

LOAD *

WHERE DSDENAME<>'CLOSED';

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) ;

6 Replies
adamdavi3s
Honored Contributor

Re: HELP excluding a certain value from a field

This should work?

LOAD *

WHERE DSDENAME<>'CLOSED';

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) ;

Re: HELP excluding a certain value from a field

But why would this not work Adam?

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) AND (DSDENAME<>'CLOSED';

adamdavi3s
Honored Contributor

Re: HELP excluding a certain value from a field

I wasn't aware you could mix where and where exists like that but of course you can, sorry I keep my QVD loads optimised so not a situation I've really messed with before

Maybe its just a case of an erroneous bracket then and this will work?

LOAD BRNO AS LNK_BRNO,

  BRNO,

    BRENAME,

   RSMENAME,

   DSDENAME

FROM*********************************************(qvd)

WHERE EXISTS (LNK_BRNO,BRNO) AND DSDENAME<>'CLOSED';

Re: HELP excluding a certain value from a field

Yup that could be the issue

aaronnayan
Contributor III

Re: HELP excluding a certain value from a field

THANKS GUYS FOR ALL THE HELP

ADAM U SMASHED IT CHEERS PAL

adamdavi3s
Honored Contributor

Re: HELP excluding a certain value from a field

We're glad to help

Please remember to close the thread by marking the correct (and any helpful) answers