Label (PQL)

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

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

Syntax

Label( <Axis Integer> , <Row Integer> , <Column Integer> )

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

Comments
  • The axis, row and column zero-based index numbers must be supplied to indicate which data point to return.
  • Axis 0 represents columns, while axis 1 represents rows.

Examples

The examples below use the following example grid.

This example returns Female (column axis:0, first row of column labels:0, first column of column labels:0):

Label(0,0,0)

This example returns Male (column axis:0, first row of column labels:0, second column of column labels:1) Notice that the spanned columns are removed from the counts:

Label(0,0,1)

This example returns Bachelors (column axis:0, second row of column labels:1, third column of column labels:2):

Label(0,1,2)

This example returns Married (row axis:1, first row of row labels:0, first column of row labels:0):

Label(1,0,0)