Discussion Board for collaboration on QlikView Scripting.
I have a question regarding range of values in scripting.
In my script I do the following
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
Go to Solution.
Where Match([product code], 29306, 29307, 29310,...);
Can this also be used as
Where Not Match([Product code],29306,....);
And with more statements