Column selection for visualizations in TIBCO Spotfire using property controls fails for some columns (where the column name contains space characters)
Article ID: KB0072356
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All |
Description
Consider the below data set.
Name Age Sex Order ID
| John | 23 | m | 1234 |
| Tanya | 19 | f | 7863 |
| Cena | 42 | m | 7856 |
| Jill | 40 | f | 8907 |
Create a Drop-down Property control named "test" in text area to dynamically choose the column for X axis of the Bar Chart visualization. In the X-axis of Bar Chart Visualization using the expression "${test}" rightly populates the column selected in the Property Control for all columns except for "Order ID".
When Property control selected is "Order ID" the Bar Chart Visualizations throws an error " The expression is not valid after 'Order' on line 1 character 1. The reason for this is because of the space between 'Order' and 'ID' in the 'Order ID' column.
Resolution
To ensure that the expression handles the blank space properly, alter the custom expression for the X-axis of the Bar Chart Visualization to <$esc(${test})>. This syntax is used automatically when using the "Set From Property" functionality on an axis selector. For an example, please refer to the attached analysis file.
More information on this general topic, further explaining the use of the $esc function, can be found in the page Troubleshooting Property Expressions, in the TIBCO Spotfire Analyst User's Guide: https://docs.tibco.com/pub/sfire-analyst/11.4.3/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=prop%2Fprop_troubleshooting_property_expressions.htm
More information on this general topic, further explaining the use of the $esc function, can be found in the page Troubleshooting Property Expressions, in the TIBCO Spotfire Analyst User's Guide: https://docs.tibco.com/pub/sfire-analyst/11.4.3/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=prop%2Fprop_troubleshooting_property_expressions.htm
Issue/Introduction
Column selection for visualizations in TIBCO Spotfire using property controls may fail for some columns, with errors like "The expression is not valid after 'xxx' on line 1 character 1". This article describes how to handle the case where the column name contains blank space.
Additional Information
- Troubleshooting Property Expressions, TIBCO Spotfire Analyst User's Guide
Feedback
Yes
No
Powered by
