topic Re: adding a where condition in QlikView

adding a where condition

Anonymous — Tue, 18 Apr 2017 12:35:53 GMT

i need to limit my load with some where condition in my script where x='asdjfj' like thi there are 10 values ,how to do that ,

if am just direct writing like x='bfjbdj','jdfhjhj','sdhfjsdgfj' ..........................................like this for 10 values

after my load statement ,its showing wrong syntax.

swuehl — Tue, 18 Apr 2017 12:39:24 GMT

LOAD Field

FROM ...

WHERE Match(Field,'asdfg','xyz','fsa','1234');

Anonymous — Tue, 18 Apr 2017 14:30:52 GMT

FROM

[\QVD\.qvd]

(qvd) where x<>'-9999' and y='Sat' and Match(z,

'1610023353422|Z14N142927'

'1591060447759|Z16N226152'

'2199996076857|Z15N401814'

'2000016218700|Z16N063696'

'1900037188652|Z16N173636'

'2000026037752|Z15N413836'

'2310296834017|Z16N140769'

'1610020185660|Z16N215765'

'1610027257568|Z13QU58933'

'1610002252481|Z16QU45021')

this is gvng me syntax error

swuehl — Tue, 18 Apr 2017 14:34:01 GMT

Match() function requires commas separating the values you want to compare against.

Anonymous — Wed, 19 Apr 2017 10:39:07 GMT

its not working,

swuehl — Wed, 19 Apr 2017 11:39:12 GMT

'It's not working' is not a good issue description, could you elaborate a bit more detailed?