Expression: Queries

FastStats allows you to use existing queries in expressions. These must be dragged onto the expression panel to be added to the expression. These are most useful when used in logical functions. For each record, the query evaluates to 1.0 if query is true, and 0.0 otherwise.

When they are added to the expression, the query placeholder is shown in green, surrounded by curly braces as shown below.

InList(1.0,{Query #1 - Low Income},{Query #2 - Middle Income})

In the preceding example, the expression would evaluate as:

If this record is in the low income query then 1.0

else if this record is in the middle income query then 2.0

else Missing Value

 

See also - Expressions Overview, Logical Functions