Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Property control to change the X-axis of a Bar Chart visualization works only for some columns.
Solution:
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. The custom expression in the X-axis of the Bar Chart Visualization has to be changed to either <[${test}]> or <$esc(${test})> to get this to working.
Refer to the attached analysis file.
Comments
0 comments
Article is closed for comments.