Where with multiple values

[qlikviewaf]

Hieveryvone, i'm loading a qvd file and i want to set a where clause with multiple values.

What is wrong in my statement below?

Thank you for your time.

[sunny_talwar]

May be try like this

Where not WildMatch(SDDCTO, 'CR', 'SR', 'UK', ......)

[prieper]

You cannot add multiple expressions with a logical operator,

easiest would be to use Sunny's suggestion.

Simplified you may also write

WHERE SDDCTO <> 'CR' AND SDDCTO <> 'SR' AND SDDCTO <> 'UK' etc. (analogue to the second row of your where-clause).