Thursday, October 27, 2016

Spotfire Shortcut keys

Ctrl+A               
 Mark filtered rows
 Ctrl+C               
 Copy the marked records to the clipboard as text
 Ctrl+D                
 Create Duplicate Active page
 Ctrl+E                
 Unmark the set of marked records
 Ctrl+F                
 Find the entered text in the entire file
 Ctrl+I                 
 Inverts the set of marked records
 Ctrl+N               
 New Page
 Ctrl+O               
 Open an existing file or a file to import
 Ctrl+P                
 Launch the Print Layout Options tool
 Ctrl+R              
 Reset all filters
 Ctrl+S              
 Save the current analysis file
 Ctrl+T               
 Create a new text area
 Ctrl+U              
 Duplicate visualization
 Ctrl+V              
 Paste the clipboard contents into Spotfire
 Ctrl+W             
 Close the current analysis file
 Ctrl+Y              
 Redo
 Ctrl+Z               
 Undo
 Ctrl+1              
  New table 
 Ctrl+2              
  New cross table
 Ctrl+3              
  New bar chart
 Ctrl+4              
  New line chart
 Ctrl+5              
  New combination chart 
 Ctrl+6              
  New pie chart
 Ctrl+7              
  New scatter plot
 Ctrl+8              
  New 3D scatter plot
 Ctrl+9              
  New map chart
 Ctrl+0              
  New graphical table
 Ctrl+Shift+1    
  New tree map
 Ctrl+Shift+2    
  New heat map
 Ctrl+Shift+3    
  New parallel Coordinate plot
 Ctrl+Shift+4    
  New summary table
 Ctrl+Shift+5    
  New box plot
 Ctrl+F4            
 Close the active visualization
 Delete             
 Delete Marked rows
 Alt+F4              
 Exit Tool
 F1                     
 Open online help

Wednesday, October 26, 2016

Spotfire HTML formatting (Horizontal) for filters in textarea

<table>
<tbody>
<tr>
    <td valign="top"><p align="left">(Write heading 1 here)</p></td>
    <td valign="top"><p align="left">(Write heading 2 here)</p></td>
</tr>
<tr>
    <td> (Add filter control 1 here)</td>
   <td> (Add filter control 2 here)</td>
</tr> 
</tbody>
</table>

Few suggestions:
Repeat section in  <td></td> (orange marked) for more filters
Change valign = middle / bottom as required.
Write <table bgcolor=”red”> to give red color to canvas


More advance is there and you can build very nice webpage  with css and jquey.

Spotfire HTML formatting (Vertical) for filters in textarea



<table>
<tbody>
<tr>
<td valign="top"><p align="left">(Write heading 1 here)</p></td>
<td> (Add filter control 1 here)</td>
</tr>
</tbody>

</table>

Few suggestions:
Repeat Yellow marked part for more filters
Change valign = middle / bottom as required.
Write <table bgcolor=”red”> to give red color to canvas

Toggle the filter panel show\hide

if (Document.ActivePageReference.FilterPanel.Visible == False):
   Document.ActivePageReference.FilterPanel.Visible = True
else:
   Document.ActivePageReference.FilterPanel.Visible = False

Toggle the details-on-demand panel on\off

if (Document.ActivePageReference.DetailsOnDemandPanel.Visible == False):
   Document.ActivePageReference.DetailsOnDemandPanel.Visible = True
else:
   Document.ActivePageReference.DetailsOnDemandPanel.Visible = False

Reset Filters in spotfire using IronPython

# Reset Filters in spotfire using IronPython
for scheme in Document.FilteringSchemes:
     scheme.ResetAllFilters()

Reset All Marking in spotfire using ironpython

# Import required libraries
from Spotfire.Dxp.Data import *
from Spotfire.Dxp.Application.Filters import *

# Loop through each data table
for dataTable in Document.Data.Tables:
 for marking in Document.Data.Markings:
  rows = RowSelection(IndexSet(dataTable.RowCount, False))
  marking.SetSelection(rows, dataTable)

Change default value for Listbox in spotifre

Document.Properties['test'] = 'papa'