VQ returns the symbol/qualifier (<, > or ND) for a given variable result.
SYNTAX:
VQ(VarNum, offset/Date, optional interval, optional interval Number)
VarNum: The variable number to get text value for.
Offset/Date: If the field is numeric it is assumed to be the offset and is defined as the offset from the start date of the report. For example, if the start date is 1/1/2000 and the offset is 1, the value from 1/1/2000 will be returned. If the offset is 2, the value from 1/2/2000 will be returned and so forth. If the field is a date in quotes or a cell reference to a cell containing a date the value for the date will be returned.
Interval: Used to retrieve data outside the report date range. The interval sets whether to go back years (yyyy), months (m), etc… The following are the valid settings for Interval:
yyyy Year
q Quarter
m Month
y Day of year
D Day
w WeekDay
ww Week
IntervalNum: Used to retrieve data outside the report date range. The interval number set the number of Intervals to go back.
EXAMPLES:
Equation |
Variable Result |
Returned |
VQ(4011,1) |
<4 |
< |
VQ(11,2) |
>500 |
> |
VQ(1,5) |
2.7 |
"" - nothing returned |
VQ(11,B7) |
ND |
ND |