Analysis.SelectionCondition
This property returns the selection conditions for the analysis.
SVB Example
Customizing an analysis selection conditions:
Option Base 1 Option Explicit Sub main Dim newanalysis As Analysis 'create a new Basic Statistics analysis using the active dataset Set newanalysis = Analysis (scBasicStatistics, ActiveDataSet) Dim SelCond As SelectionCondition 'set the analysis selection conditions to the SelCond variable Set SelCond = newanalysis.SelectionCondition 'set the Selection Condition Include list to include only cases '1-5 in the analysis SelCond.IncludeList = "1:5" 'enable the selection condition SelCond.Enabled = True 'set the selection condition source option to the analysis 'instead of those specified within the spreadsheet. newanalysis.SelectionConditionSource = scSourceLocal 'display the analysis, notice that the 'Select Cases' button 'is enabled newanalysis.Visible = True End Sub
Copyright © 2020. Cloud Software Group, Inc. All Rights Reserved.