Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Feb 6, 2016

Allow use of property control display names in expressions for calculations

In Spotfire, when a property control is created and the 'set property value through' prompt is selected as expression or fixed value, you will have the option to define a name and also a value for the property. When using this property in other places, the value is always used for calculations, while the name is used for display purposes.

There are many cases where the actual name of the property needs to be used as well (in addition to the value). However, there is no way to access the name of the property. It would be great if we could create a way to access the name of a property.

Users scenario explanation :

I am attaching dataset and the .DXP file (with embedded data). In the .DXP file, if you look at the second page, I have a cross table with a property control on the left for selecting the Data Type (you can ignore the second property control). The property control names are integer, date, and text, but the values are actually expressions( see screenshots). The expressions control what columns are displayed in the cross table.

However, I would also like to limit the data in the cross table based on the property control selection, i.e. if the user selects ‘Date’ in the property control, then I want to only show rows with [Type]=”Date”. This is not directly possible, because I do not have access to the property name. I have implemented a workaround to find the word ‘Date’ in the expression (i.e. the property control value), but this workaround may not be straightforward in all cases. It would be much easier if I had access to the property name (e.g. ‘Date’ or ‘Integer’ or ‘Text’).

Please consider this as future enhancement.

  • Attach files