Referencing a Column with Positional (Index) Filtering
You can filter out records of a column based on a range of row indices. For example, consider the table described previously (Referencing a Query Column). To extract the first five records from the 'company_name' column, adapt the formula as follows:
q['[0,company_name]:[4, company_name]'];
An asterisk '*' in place of the row index represents the last row in the result set.
| << Referencing a Column With Expression Filtering | © 1996-2013 InetSoft Technology Corporation (v11.4) | 3.7.4 Cell Referencing >> |