I wish display the "Display Name" (drop down property) in the table but currently i only able to display the expression....anyone know the tricks?

[Chee Kheong Wan]

Please refer to attachment

Goal : To display "S1" or "S2" base on selection

Current : Display expression base on selection

[Jose Leviaguirre]

Hello Chee

There is currently no way to display the selected value from the dropdown other than the value itself. Please vote for this idea

As a work around, you can create a calculated column like this:

case "${yourDocProp}"
   when "YourExpression 1" then "S1"
   when "YourExpression 2" then "S2"
   else "${yourDocProp}"
end

The else statement will show the expression if the expression is not found on any other cases in case there is a typo. You can write your expression within the when clause in uppercase and wrap"${yourDocProp}" with Upper("${yourDocProp}")

case "UPPER(${yourDocProp}")
   when "YOUR EXPRESSION 1" then "S1"
   when "YOUR EXPRESSION 2" then "S2"
   else "${yourDocProp}"
end

 

[Vincent Thuilot]

Hello Jose

I tried what you proposed in one of my project but it seems not working easy when expressions already contain other property values.

For instance i have this expression in a property expression: 

Sum(IF([Column1]="${Property1}",${MapMetricMS},0))/Sum(${MapMetricMS})

if i use it in the CASE/WHEN with "", it does not keep it as text and it kinda mess around, any idea?

It works fine if there are no reference to other property values.

Thanks in advance for the support!

Vincent

PS: i tried to look at the idea you suggested to vote for it but unfortunately it's not working anymore, shall I create a new one?

 

 

 

 

[Kirsten Smith (she/her)]

The Ideas Portal for Spotfire enhancement requests has been separated into its own entity.  Try this link:

 

https://ideas.spotfire.com/ideas/SPF-I-76