Hide Pages without using any Script/Code

1. Go to Edit > Document Properties > General

2. Set Navigation Mode to History Arrows.
3. Add a text area to be used as Navigation Bar.
4. Edit Text Area 
5. Insert Action Control.
6. Set Control type to "Link" (or based on your preference), and add Action Pages and Visualization > Page - II

7. Repeat Step 6 & 7 for pages you want to show.

Done

Read More

Read Table Visualization data in a string using IronPython

Read Table Visualization data in a string using IronPython
Script	Information
from Spotfire.Dxp.Application.Visuals import TablePlot, HtmlTextArea import clr import sys clr.AddReference('System.Data') import System from System.Data import DataSet, DataTable, XmlReadMode from Spotfire.Dxp.Data import DataType, DataTableSaveSettings,IndexSet, RowSelection, DataValueCursor, DataSelection, DataPropertyClass,Import from System.IO import StringReader, StreamReader, StreamWriter, MemoryStream, SeekOrigin, FileStream, FileMode,Path from Spotfire.Dxp.Data.Import import TextFileDataSource, TextDataReaderSettings from System import Array stream=MemoryStream() writer=StreamWriter(stream) #Export TablePlot data to memory stream tablePlot= tablePlot.As[TablePlot]() tablePlot.ExportText(writer) f = System.Text.Encoding.UTF8.GetString(stream.ToArray(),0, stream.Length) print f	The Script provided here can be used to read Table Visualization data in a string using IronPython in Spotfire Analysis file. Variables #tablePlot is Table Plot Visualization

Read More

Apply User based security using IronPython

Apply User based security using IronPython
Script	Information
# Delete datatable if logged user other than desired (Data Table Security) from System.Threading import Thread uName= Thread.CurrentPrincipal.Identity.Name if uName!="Desired User": Document.Data.Tables.Remove(Document.Data.Tables["Data Table"]) #Delete Column programmatically (Column Level Security) if uName!="Desired User": dt.Columns.Remove("Column Name") #Delete Page programmatically (Page Level Security) if uName!="Desired User": for Page in Document.Pages: if Page.Title == "Secured Page": Document.Pages.Remove(Page)	The Script provided here can be used to apply user based security using IronPython in Spotfire Analysis file. The scrip provided here discusses about three different types of Security based on current logged user. Variables #dt is Data Table

Read More

Apply Filter from text input using IronPython

Apply Filter from text input using IronPython
Script	Information
from Spotfire.Dxp.Data import * from System import Array,String import Spotfire.Dxp.Application.Filters.ListBoxFilter from Spotfire.Dxp.Application.Filters import ListBoxFilter,FilterTypeIdentifiers rSelect=dt.Select('Nature ~= "'+txtInput+'"') cur=DataValueCursor.CreateFormatted(dt.Columns["Nature"]) key=dict() for row in dt.GetRows(rSelect.AsIndexSet(),cur): v=cur.CurrentValue for t in v.split(', '): key[t]=1 stArray=Array.CreateInstance(str,len(key)) i=0 for k in key: stArray[i]=k i=i+1 mPan=Document.ActivePageReference.FilterPanel mFil=mPan.TableGroups[0].GetFilter("Nature") mFil.FilterReference.TypeID=FilterTypeIdentifiers.ListBoxFilter lbFil=mFil.FilterReference.As[ListBoxFilter]() lbFil.IncludeAllValues=False if stArray!=String.Empty: lbFil.SetSelection(stArray) else: lbFil.Reset()	The Script provided here can be used to apply Filter from text input using IronPython in Spotfire Analysis file . Here script is applying filter on Datatable column 'Nature'. Variables #txtInput is Text Input Property control #dt is Data Table

Read More

Toggle stack mode of Bars in BarChart visualization from python

Toggle stack mode of Bars in BarChart visualization from python
Script	Information
from Spotfire.Dxp.Application.Visuals import BarChart,StackMode v=v.As[BarChart]() if v.StackMode==StackMode.None: v.StackMode=StackMode.Stack elif v.StackMode == StackMode.Stack: v.StackMode=StackMode.Stack100Percent else: v.StackMode=StackMode.None	The Script provided here can be used to toggle stack mode of Bars in BarChart visualization . Variables #v is BarChart Visualization reference

Read More

Set BarChart Visualization Transparency from python

Set BarChart Visualization Transparency from python
Script	Information
from Spotfire.Dxp.Application.Visuals import BarChart vis=vis.As[BarChart]() vis.Transparency=tnum	The Script provided here can be used to set transparency of Bars in BarChart visualization . Variables #vis is BarChart Visualization reference #tnum is Real value between 0.0 and 1.0, residing in a property, and represents transparency level

Read More

Update Manual trellis layout of Visualization

Update Manual trellis layout of Visualization
Script	Information
from Spotfire.Dxp.Application.Visuals import VisualContent from Spotfire.Dxp.Data import * mychart.As[VisualContent]().Trellis.PanelAxis.Expression=expr if TrellisSelector=="2x2": mychart.As[VisualContent]().Trellis.ManualColumnCount = 2 mychart.As[VisualContent]().Trellis.ManualRowCount = 2 else: mychart.As[VisualContent]().Trellis.ManualColumnCount = 2 mychart.As[VisualContent]().Trellis.ManualRowCount = 1	The Script provided here can be used to set Manual trellis layout programatically. Assuming that trellis is initialised in panel mode already. Variables #expr is a string containg Trellis PanelAxis expression stored in Property #TrellisSelector is a string containg layout indicator stored in Property

Read More

Update Color By Expression of Visualization

Update Color By Expression of Visualization
Script	Information
from Spotfire.Dxp.Application.Visuals import ColorAxis, VisualContent from System.Drawing import Color v = v.As[VisualContent]() if hasattr(v,'ColorAxis'): v.ColorAxis.Expression=expr c= v.ColorAxis.Coloring c.AddCategoricalColorRule()	The Script provided here can be used to update color by expression for a visualization with color axis. If visualization doesn't have any ColorAxis, script doesn't perform any action. Variables #v is BarChart reference #expr is a expression string stored in Property

Read More

Row count for the occurrences of a cell value in a column

Row count for the occurrences of a cell value in a column
Script	Information
from Spotfire.Dxp.Application.Filters import CheckBoxFilter filter=Document.FilteringSchemes[0].Item[myDataTable].Item[myDataTable.Columns.Item["Region"]].As[CheckBoxFilter]() #uncheck all filter.IncludeEmpty = False #make sure to clear the empty values for value in filter.Values: filter.Uncheck(value) #check one filter.Check(regionName) rows = Document.ActiveFilteringSelectionReference.GetSelection(myDataTable).AsIndexSet() print rows.Count for value in filter.Values: filter.Uncheck(value)	The Script provided here gives the row count for the occurrences of a cell value in a column specified, given condition is - the filter type of the column should be check box filter in Active Filtering Scheme. Variables #myDataTable : DataTable reference to apply filter on #regionName : Cell Value to be counted

Read More

Hide all but Color by in Legend

Hide all but Color by in legend
Script	Information
#This script hides all but Color by in legend, including color axis selector and title from Spotfire.Dxp.Application.Visuals import VisualContent page=Document.ActivePageReference for v in page.Visuals: vis=v.As[VisualContent]() try: for legendItem in vis.Legend.Items: legendItem.Visible=False if legendItem.Title == "Color by": legendItem.Visible=True legendItem.ShowTitle=False legendItem.ShowAxisSelector=False except: print "Missing Color Legend"	The Script provided here hides all but Color by in legend, including color axis selector and title in active page of analysis. If a visualization doesn't have color by legend of legend option itself (e.g. TextArea), the script simply ignores that Visualiztion. Variables #NA

Read More

Build Information Links for a complex SQL Query

Build Information Links for a complex SQL Query
Steps
1. Run Query and get the details of result set column names with data type. 2. Pick a table from SQL query, and using it create elements. Save the elements with Same name and data type retrieved in step 1. Do not bother about what column you are using, just focus on data type of column, and save with the name retrieved earlier. 3. Use these elements to create information link as usual. 4. Keep Order of column elements in IL same as in result set of step 1. Any other order may create issues. 5. Edit SQL and replace whole custom SQL contents with your complex query Done
Information
The steps provided here can be used to build Information Links for a complex SQL Query, which may contain multiple sub-queries,joins, group by. order by etc. Notes: All the joined tables should be in same schema and DB. The Data on demand setup with this approach may create some issues, if resulting SQL query is not configured properly. in order to make IL support Data on Demand, "and " should be palced in according to SQL where clause.

Read More

Extract unique values in Data Table Column

Extract unique values in Data Table Column
Script	Information
from Spotfire.Dxp.Data import * columnToFetch='Column 1' rowCount = activeTable.RowCount rowsToInclude = IndexSet(rowCount,True) cursor = DataValueCursor.CreateFormatted(activeTable.Columns[columnToFetch]) ctrl = 0 uc=dict() for row in activeTable.GetRows(rowsToInclude,cursor): rowIndex = row.Index val = cursor.CurrentValue uc.update({val:ctrl}) #print val ctrl = ctrl + 1 #print uc for key in uc: print key	The Script provided here can be used to extract unique values in Data Table Column in Plain Text format. Variables #activeTable : Data Table containing target column

Read More

Extract All Script from Spotfire Analysis in in Plain Text

Script

for sc in Document.ScriptManager.GetScripts(): print "Script Name : ",sc.Name print "Code :" print sc.ScriptCode

Information

The Script provided here can be used to extract All Script from current Spotfire Analysis file in Plain Text format. Variables #NA

Read More

Toggle Marking Behavior

Toggle Marking Behavior from Show Empty to Show All
Script	Information
from Spotfire.Dxp.Data import LimitingMarkingsEmptyBehavior from Spotfire.Dxp.Application.Visuals import VisualContent v = vis.As[VisualContent]() if v.Data.LimitingMarkingsEmptyBehavior == LimitingMarkingsEmptyBehavior.ShowAll: v.Data.LimitingMarkingsEmptyBehavior = LimitingMarkingsEmptyBehavior.ShowEmpty else: v.Data.LimitingMarkingsEmptyBehavior = LimitingMarkingsEmptyBehavior.ShowAll	The Script provided here can be used to toggle marking behavior of a visualization i.e. it can change the content to be displayed in case no items are marked in master visualization of current detailed visualization. The IronPython Script is programmed to change between Show all data and Show Empty visualization, in case nothing is marked in Master visualization. Variables #viz: Detailed Visualization

Read More

Convert Cross Table to Data Table

Convert Cross Table to Data Table
Script	Information
import clr clr.AddReference('System.Data') import System from System.Data import DataSet,DataTable from System.Data.Import import TextFileDataSource,TextDataReaderSettings,DataType,DatTableSaveSettings,AddRowsSettings from System.IO import Path,StreamWriter,StringReader,StreamWriter,MemoryStream,SeekOrigin from Spotfire.Dxp.Application.Visuals import CrossTablePlot stream=MemoryStream() writer=StreamWriter(stream) viz.As[CrossTablePlot]().ExportText(writer) stream.Seek(0,SeekOrigin.Begin) readerSettings=TextDataReaderSettings() readerSettings.Separator="\t" readerSettings.AddColumnNameRow(0) textDataSource =TextFileDataSource(stream,readerSettings) dataTable.ReplaceData(textDataSource)	The Script provided here can be used to replace data in a data table with content in a cross table plot. Variables #viz: Cross Table Visualization #dataTable: Target Data Table

Read More