LookUpDisplay DataWindow expression function
Description
Obtains the display value in the code table associated with
the data value in the specified column.
Syntax
|
1 |
<span>LookUpDisplay</span> ( <span>column</span> ) |
|
Argument |
Description |
|---|---|
|
column |
The column for which you want the code |
Return Values
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 |
<span>LookUpDisplay</span>(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 |
<span>LookUpDisplay</span>(product_type) |