How to make Statistica Enterprise use the user-defined specification in IQC chart when the specification is available in the data configuration ?
Article ID: KB0080101
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10 and later versions |
Description
PREREQUISITES
Existing Data Configuration with characteristics and first update columns
Location of User defined Specification
Existing IQC Analysis Configuration
Issue/Introduction
Resolution
Method 1: The specification exists as a column in the data configuration that the analysis configuration is dependent on
1. In the data configuration, the analysis configuration is dependent on, expand the query to see specific fields retrieved by the query
2. Click on the field in which the specification is available. Change the Target type from 'Data' to "Specification'. Specify the appropriate specification type and select the characteristics it applies to.
3. Click Commit. The IQC Analysis configuration will now use the user-defined specification in the dataset instead of calculating the control limits.
Method 2: Specification is Static (or) on another table that can be queried.
1. Expand the analysis configuration where the user defined specification is to be used . Expand the SPC Characteristics>>Variable characteristic and select Specifications. Click on Add.
2. Select the type of specification from the drop down list. If using a static value, enter the static value and click OK.
3. If the value needs to be queried, select SQL wizard on Advanced SQL Wizard in the Specification SQL Statement section to use the query builder or type the SQL statement.
4. Click on Add.
5. Select the type of specification and choose Queried value. Pick the column from drop down list that contains the value to be used as specification.
6. Click OK. Repeat the steps as deemed necessary to add other specifications to the the IQC Chart. If planning to use the control limits from user defined specification, select "Do not calculate control limits for the X-chart" . Evaluate if the option to calculate control limits for R-chart needs to be turned off as well and if specifications should be added to the data file. Click on Commit button to save the changes to the IQC Analysis.
7. If Lower Specification and Upper Specification is specified, user should also evaluate if this needs to be shown in chart and enable "Show process specification and specification limits in the chart" under SPC characteristics >>Variable characteristic>>Layout and commit the change
8. Run the analysis configuration to see the chart with user defined specifications.
Feedback
