How to set the Range Filters Min and Max value Using iron Python

[Mohanvel Rajendran]

Hi All,

I need to get a min and max value from a specific columns and I need to set that min and max value as a range in slider which should present in a text area.

By using below code i Can able to get the min and max value from the column "Total # of subjects with Queries". But I dont have an idea about how to set this in a slider which is present in text area. can you please help on the same.

 

from Spotfire.Dxp.Application.Filters import *

from Spotfire.Dxp.Data import *

filters = Application.Document.FilteringSchemes[Application.Document.ActiveFilteringSelectionReference][Application.Document.ActiveDataTableReference]

filter = filters["Total # of subjects with Queries"].As[RangeFilter]()

activeselection=Document.ActiveFilteringSelectionReference.GetSelection(myDataTable).AsIndexSet()

column = myDataTable.Columns["Total # of subjects with Queries"]

min = column.RowValues.GetMinValue(activeselection).ValidValue

max = column.RowValues.GetMaxValue(activeselection).ValidValue

filter.ValueRange = ValueRange (min,max)

print min

print max

- I need to create 4 Range filters(Sliders) in text area including above filters and based on that range my cross table needs to be updated . So how to releate those 4 Range filters together since, I have created as individual Range Filters(Sliders).

Thanks,

Mohan

[Shandilya Peddi]

Hello Mohanvel,

Currently there is no Public API available to manage the Spotfire Controls in Text Area. So it is not possible to set the Min and Max values of a Slider property through API

[Lee Grant 2]

Is there an any tooling for this yet

I have the same question. I want the min/max of slider bar doc properties to be linked to input boxes.

[Mike Akister]

Hi Mohan,

I have successfully done what you are asking using a TERR data function...

#create a data frame using a sequence based off the filtered Min and Max and a User Specified Step

fltDf