Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

adding a where condition

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.

Labels (1)
5 Replies
swuehl
Champion III
Champion III

LOAD Field

FROM ...

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

Anonymous
Not applicable
Author

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
Champion III
Champion III

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

Anonymous
Not applicable
Author

its not working,

swuehl
Champion III
Champion III

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