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


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

  • 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.


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):


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:


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


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