topic ASK.. Simple Syntax in edit script and expression in QlikView

ASK.. Simple Syntax in edit script and expression

Wed, 25 Aug 2010 05:58:21 GMT

heelo all,

need help plis , thankss

what is syntax of "not in" or "in"??

example,

load

...

from ..... where status = 1;

and now i want to load where status is "in" or "not in" 1,2,3,

what is the syntax?

load

...

from .... where status NOT IN ('1','2','3'); <----- is that right??

from .... where status IN ('1','2','3'); <----- is that right??

plis correct me..

and in expression

usually like this,

SUM({<Status = {'1'}>}Sales)

same question,

what is the syntax of "not in" in expression??

thank you...

best regards!!

ASK.. Simple Syntax in edit script and expression

Wed, 25 Aug 2010 06:27:39 GMT

Hi Frozenring,

You can use the script as follows,

load

...

from ..... where status <> 1;

Regards!!!

Nilupa

ASK.. Simple Syntax in edit script and expression

suniljain — Wed, 25 Aug 2010 06:47:03 GMT

You can use

where (Status='1' or Status = '2' or Status ='3') ) ;

ASK.. Simple Syntax in edit script and expression

Wed, 25 Aug 2010 07:11:30 GMT

hello sunin..

then what is not in??

hello nilupaboralessa,

how to use if not in more than 1?

and what is the syntax not equal or not in , in expression??

thank you all

ASK.. Simple Syntax in edit script and expression

Wed, 25 Aug 2010 07:18:15 GMT

Hello Frozenring,

You can use as

...................WHERE STATUS<>1 OR STATUS<>2 OR STATUS<>3

Nilupa

ASK.. Simple Syntax in edit script and expression

Miguel_Angel_Baeyens — Wed, 25 Aug 2010 08:06:53 GMT

Hello Frozenring,

If you are loading from a QVD file, or you just don't want the server to do the job, I'd rather use for simplicity sake, the "match()" function for IN:

LOAD * FROM FILE.QVD (qvd)WHERE MATCH(STATUS, 1, 2, 3) > 1;

or NOT IN

LOAD * FROM FILE.QVD (qvd)WHERE MATCH(STATUS, 1, 2, 3) = 0;

Hope this helps

ASK.. Simple Syntax in edit script and expression

Wed, 25 Aug 2010 09:24:05 GMT

thank you miguel,

best regards!