Exclude range of numbers in dimensions at script level in qlik sense

[MS90]

In A dimension field I am having values from 1 to 100 and  I want to exclude values from 5 to 10 at script level.

[marcus_sommer]

Maybe: sign(match(Field,5,6,7,8,9,10)) as Flag and using it as where/selection filter or set analysis condition.

[MS90]

Thanks for replying

But in dimensions the values are like example 5.1,5.2,5.3....9.8,9.9 I need to exclude all the values at script level itself

[Or]

Load *

From SomeTable

Where SomeField >= 5 and SomeField <10; // This assumes the values are numeric or can be converted to numbers

[marcus_sommer]

This might be solved with the following adjusting:

sign(match(floor(Field),5,6,7,8,9,10)) as Flag

or you change it to something like:

-(Field >=5 and Field < 11) as Flag