Jump to content

How to assign multiple values to a display name of a ListBox (multiple select) document property?

Jung Choi

Recommended Posts


I currently have a ListBox document property have and have set property values through: fixed values. I'm able to create display names and assign a value to that display name but was wondering if it was possible to assign multiple values to one specific display name? For example, I have display name "cars" and want to assign it "honda, nissan, ford" so that if I select "cars" in the ListBox, it'll search the table for "honda" or "nissan" or "ford". Is this possible in Spotfire? Would it require an Ironpython script?

Thank you in advance!

Link to comment
Share on other sites

Hi Tushar - Thank you for your reply. I think what I need is slightly different and apologies if this wasn't clear in my original question. The display name I want is "Cars", but the value I want is the different forms that "Cars" can come in i.e. cArs, CARS, caRS, etc. Is there a way so that multiple variations of the value can be covered under one display name?

Would adding what's below as the expression to a display name work?

"cArs" or "CARS" or "caRS"


Link to comment
Share on other sites

Hi Gaia,

Appreciate your response. What if my document property is being used as an on-demand filter for multiple tables? I understand that if my document property was being used to filter on one table, we can use the expression example you've given but if my doc property is being used for multiple tables where each table has a different variation of the string, how can I set the display value to encompass all the different variations? Hope that makes sense. Thanks.

Link to comment
Share on other sites

Hello Jung Choi,

Hard for me to follow what is the exact use case based from the original question, but let me try.

It depends on how and where you are using this. If it is being used in other expressions then this can work as discussed so far. For example, you can nest multiple functions within an expression to make Cars 2022 and Cars2022 consistent. In this example, I am using lower, trim and substitute to remove and lowercase any inputs that might well come from a column and then checks with the expected output::

Substitute(Trim(Lower("Cars 2022"))," ","") in ("cars2022", "vehicles2022, vehicles22, planes")Substitute(Trim(Lower([CarsColumn])," ","") in ("cars2022", "vehicles2022, vehicles22, planes")

If you are using this as an input property for an on-demand data table then that wont work, and would require a different approach. Maybe an on-demand Input from expression or data function.

If there are too many variations to handle another approach could be to clean the data with a proper ETL before loading it to Spotfire or running specific data function to analyze these patterns.

Link to comment
Share on other sites

Hi Jose,

Thank you for your response. Basically, I want to give a user the ability to choose the string they want to use as an input property for multiple on-demand tables using a List box document property. The issue is that one table might have one variation of a string while the next table has another variation. For example, Table 1 has "Cars 2022" while Table 2 has "Cars2022". Both tables are using the same document property as an on-demand input. This is why I was hoping that when creating the document property to use as the on-demand input, that one specific display name can represent different variations of a string. I can get this to work by manually adding each variation separately as an option in the document property but this is not efficient. Hopefully this makes more sense. Any idea how we can get this to work?


Link to comment
Share on other sites

Hello Jung,

It appears that this issue might be difficult to resolve through the Community - it might be better handled as a support case, where our support engineer can interact with you more directly. If you want to explore that option, please open a case in the TIBCO Support Portal (https://support.tibco.com).

Best Regards

Fredrik, TIBCO Spotfire Support

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...