Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dynamic_girl
Creator
Creator

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.

5 Replies
swuehl
MVP
MVP

LOAD Field

FROM ...

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

dynamic_girl
Creator
Creator
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
MVP
MVP

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

dynamic_girl
Creator
Creator
Author

its not working,

swuehl
MVP
MVP

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