User`s guide

The following table will help you select the operator you need to define a query filter.
Filter createdSelectExampleValues to retrieve
<Country> Equal to USEqual to
Retrieve data for the
US only.
Values equal to a value
you specify.
<Quarter> Different
from Q4
Different from
Retrieve data for all
quarters except Q4.
Values different from a
value you specify.
<Customer Age>
Greater than 60
Greater than
Retrieve data for cus-
tomers aged over 60.
Values greater than a
value you specify.
<Revenue> Greater
than or equal to
1500000
Greater than or equal
to
Retrieve data for rev-
enue starting from
$1.5M upward.
Values greater than or
equal to a value you
specify.
<Exam Grade> Less
than 40
Less than
Retrieve data for exam
grades below 40.
Values lower than a
value you specify.
<Age> Less than or
equal to 30
Less than or equal to
Retrieve customers
whose age is 30 or
less.
Values lower than or
equal to a value you
specify.
<Weeks> Between 25
and 36
Between
Retrieve the weeks
starting at week 25 and
finishing at 36 (includ-
ing week 25 and week
36).
Values between two
values you specify that
includes those two val-
ues.
<Weeks> Not Between
25 and 36
Not between
Retrieve all the weeks
of the year, except for
weeks 25 through 36
(week 25 and week 36
are not included).
Values outside the
range of two values
you specify.
<Country> In list 'US;
Japan; UK'
In list
Retrieve data for only
the following countries:
the US, Japan, and the
UK.
Values that are the
same as several values
you specify.
2012-03-14352
Building Queries