Script To Exclude Multiple Values?

Fri, 18 Mar 2011 14:55:57 GMT

I have the following WHERE clause that I use to exlude multiple values from the "PLANT_CD" field. While this script works, I have other exclusions I must make that involves many more values for a particular field.

WHERE (PLANT_CD <> '$(vXcludeLoc1009)' AND PLANT_CD <> '$(vXcludeLoc3301)' AND PLANT_CD <> '$(vXcludeLoc3302)';

My question: Is there a way to modify the above script so that I do not have to list each exclusion individually?

For example, can I do a version of the following:

WHERE (PLANT_CD <> '$(vXcludeLoc1009)'; '$(vXcludeLoc3301)'; '$(vXcludeLoc3302)';

Any assistance is much appreciated.

Thank you,

Godfrey

Script To Exclude Multiple Values?

Fri, 18 Mar 2011 15:11:26 GMT

Hi there, try this:

WHERE not match(PLANT_CD, '$(vXcludeLoc1009)', '$(vXcludeLoc3301)', '$(vXcludeLoc3302)');

Script To Exclude Multiple Values?

Fri, 18 Mar 2011 19:15:39 GMT

Thank you Ivan, this works perfectly!

Thank you,

Godfrey

topic Script To Exclude Multiple Values? in QlikView

Script To Exclude Multiple Values?

Script To Exclude Multiple Values?

Script To Exclude Multiple Values?