Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
csmqlik01
Contributor III
Contributor III

Range of values in scripting

Hi,

I have a question regarding range of values in scripting.

In my script I do the following

Load

   ....

   ....

where [product-code] =  (29306)or(29307)or(29310)or(29388)or(29470)or(29471)or(29473)or(29474)or(29476)or(29479)

With this I have my selection, but it seems not so good for the performance

Before I used the following, I didn't receive a syntax error, but I was missing data

Where [product code] = (29306,29307, 29310,...) 

So think the first syntax is right but maybe it can be different for better performance

Best regards,

1 Solution

Accepted Solutions
sunny_talwar

3 Replies
sunny_talwar

Use Match...

Where Match([product code], 29306, 29307, 29310,...);

csmqlik01
Contributor III
Contributor III
Author

Thanks Sunny,

Can this also be used as

Where Not Match([Product code],29306,....);

And with more statements

Where ....

and ...

and ...

sunny_talwar

Yes