I have a property for column selection...how to display the column name in the trellis header instead of the contains in the column?

[Chee Kheong Wan]

I have a property for column selection...how to display the column name in the trellis header instead of the contains in the column?

[Gaia Paolini]

You can always use a custom expression. I do not understand the connection between property for column selection and trellis.

For an increased chance of a speedy reply, please have a look at these tips:

https://community.spotfire.com/s/article/Quick-Tips-on-Asking-Community-Questions

[Chee Kheong Wan]

Hi, thanks for reply...maybe i attached the example here to make it clearer

Here is what i try to do...

 

My actual issue, i going the have a column selection for Process A to Z, and each process going to have different control limits.

And i want to associate the limit control table to the chart; where the limit going to change according to the process i going to choose.

Thus, i will need the process name to display at the trellis header.

[Gaia Paolini]

Would this work for you:

Right click on the Trellis variable to get to the Custom Expression editor

Type the expression:

<Concatenate("${ColumnSelection}","= ",${ColumnSelection}) as [${ColumnSelection}]>

by adding the ".." around the first document property, you get its name and not its value.

So the headers are now: MachineID= M101 etc.

[Chee Kheong Wan]

Thanks!...the expression works! 😀 👍