LookUpDisplay
DataWindow expression function
Description
Obtains the display value in the code table associated with the data
value in the specified column.
Syntax
|
1 |
LookUpDisplay ( column ) |
|
Argument |
Description |
|---|---|
|
column |
The column for which you want the code table display |
Return value
String. Returns the display value when it succeeds and the empty
string (“”) if an error occurs.
Usage
If a column has a code table, a buffer stores a value from the data
column of the code table, but the user sees a value from the display
column. Use LookUpDisplay to get the value the user sees.
Code tables and data values and graphs
When a column that is displayed in a graph has a code table, the
graph displays the data values of the code table by default. To display
the display values, call this function when you define the graph
data.
Examples
This expression returns the display value for the column
unit_measure:
|
1 |
LookUpDisplay(unit_measure) |
Assume the column product_type has a code table and you want to use
it as a category for a graph. To display the product type descriptions
instead of the data values in the categories, enter this expression in the
Category option on the Data page in the graph’s property sheet:
|
1 |
LookUpDisplay(product_type) |