Is there any way (using Iron Python or by some other means) to dynamically set (by user) the number of Locked Columns in a Consumer Level, web, Spotfire Visualization

[Scott Loetman]

Hello all,

I am aware that I can lock a certain number of columns in a Table visualization in Spotfire, but I have a request to, by user, for a Consumer using the Web version of Spotfire, dynamically change this value.

Thanks in advance!

Scott

[Shandilya Peddi]

You can do the following,

1. Create a Text Area with input field to define how many columns to freeze

2. use the below script to freeze the columns

 

from Spotfire.Dxp.Application.Visuals import *

#add a script parameter 'vis' refering to the tableplot

tablePlot=vis.As[TablePlot]()

tablePlot.FrozenCount=Document.Properties["myInputField"]

[Scott Loetman]

Hi Shandilya,

 

Thanks for the quick reply! I will give this a try ...

 

Scott