ValueLoop - chart function
ValueLoop() returns a set of iterated values which, when used in a calculated dimension, will form a synthetic dimension.
The values generated will start with the from value and end with the to value including intermediate values in increments of step.
Syntax:
ValueLoop(from [, to [, step ]])
Return data type: dual
Arguments:
Arguments | Description |
---|---|
from | Start value in the set of values to be generated. |
to | End value in the set of values to be generated. |
step | Size of increment between values. |
Examples and results:
Example | Result |
---|---|
ValueLoop(1, 10) |
This creates a dimension in a table, for example, that can be used for purposes such as numbered labeling. The example here results in values numbered 1 to 10. These values can then be referenced in an expression. |
ValueLoop(2, 10,2) |
This example results in values numbered 2, 4, 6, 8, and 10 because the argument step has a value of 2. |