Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Mohanvel Rajendran

Recommended Posts

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

Link to comment
Share on other sites

  • 4 weeks later...
  • 9 months later...
  • 8 months later...

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...