Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
csmqlik01
New Contributor II

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,

Tags (1)
1 Solution

Accepted Solutions

Re: Range of values in scripting

Yes

3 Replies

Re: Range of values in scripting

Use Match...

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

csmqlik01
New Contributor II

Re: Range of values in scripting

Thanks Sunny,

Can this also be used as

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

And with more statements

Where ....

and ...

and ...

Re: Range of values in scripting

Yes

Community Browser