Data (PQL)

Returns the value of a data point or cell for the given row and column index coordinates from a query result set. 

  • Returned Output: Numeric
  • Library: PQL \ Dynamic \ Grid
  • Version: 2018.00.000
  • Compatibility: Any content (regardless of data source) in the relevant parts of the application

Syntax

Data( <Row Integer> , <Column Integer> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The row and column zero-based index numbers must be supplied to indicate which data point to return.

Examples

The examples below use the following example grid.

This example returns the value 233,194, representing Adihash Bachelors:

Data(1,0)

This example sums the values of the cells Acme Bachelors and Ribuck Partial College:

Data(0,0) + Data(8,3)