Exclusion of a value for a field in creating a variable

Hi All,

We have to create a variable which has to include all the values except a single values.
Lets say a column has all the country names a country called ‘Finland’ has to be excluded to get the values from the variable.

Note: we have return the variable definition as (select country from table-name where country <>‘Finland’) .

When used in the creation of panel the variable does not works.

Thanks in advance

Puneet Agarwal