SHOWVALUES
To display values from a query in a boxed table use the SHOWVALUES() function in an event. Select the source and the size of your table, a event should trigger. The table can be scrolled through and closed again.
Syntax
=SHOWVALUES(Datasource, Target, [Alignment])
Arguments
| Name | Type | Description |
|---|---|---|
| Datasource | Cell | A cell with a query (e.g. TIMESCALE.SELECT(), TIMEAGGREGATE()) |
| Target | Range or String | A range or a shape name to display the data over. The shape name has to be put in quotes |
| Alignment (optional) | String | Define the alignment of the value table relative to the shape or range. Allowed alignment definitions are "right", "left" or "center". Default is "right" |
Return
| Type | Description |
|---|---|
| Boolean | TRUE. |
Hint
This function should not be used in a cell
Examples
| Formula | Result | Comment |
|---|---|---|
| If this formula is assigned to a shape event, queried data from C6 will be shown in a table covering K2:N7. |