Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

how to set the control limit for a column using other columns?

Created:
Sep 30, 2020 11:56 AM
| Last Modified: Oct 12, 2020 3:20 AM
(447 views)

Hi every one.

I know this question might be repeated. I have read all answers for example Getting control limits from column property

I have a column (:X) and I have three columns for :X control limits, (UCL,LCL, Ave). and I like to set the control limits to :X, but I am confused.

I tried ;

:X<<Set Property("Control Limits", {XBar(Ave(:Center Line[1]),LCL( :Lower Limit[1] ), UCL( Upper Limit[1] )), Show Control Limits( 1)});

But it does not work.

Also, sometimes in UCL,LCL, and AVE columns, I have different values for different rows in :X

I know it is not possible to have different set of Spec limits for a Colum but I was wondering if there is a way to do that for Control limit.

Thanks

12 REPLIES 12

Highlighted
##

Sorry, I'm a bit confused by your inquiry. Why don't you let JMP calculate the control limits (or create control charts) on your x column? You realize control limits are a function of the data, how it was collected and how you are subgrouping it?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

Thanks @statman

I am creating a report and my data table include all data that I pull by JMP. I wrote an script for my report and making a HTML report at the end. This script has to be run every day, so I am not sure if I can do what you are suggesting.

Highlighted
##

Hopefully you aren't just changing control limits every day? And hopefully the control limits are appropriate for your data set.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

No the data table will be updated daily too. and all the data are pulled out from the same tool and appropriate.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

The values within Lists will not be executed, therefore, you need to use the below methodology to create the JSL needed to upload the Control Limits

```
Eval(
Substitute(
Expr(
:X << Set Property(
"Control Limits",
{XBar( Ave( __avg__ ), LCL( __LCL__ ), UCL( __UCL__ ) ),
Show Control Limits( 1 )}
)
),
Expr( __avg__ ), :Center Line[1],
Expr( __LCL__ ), :Lower Limit[1],
Expr( __UCL__ ), :Upper Limit[1]
)
);
```

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

Thanks Jim

this method works for the Spec limits but does not show the control limits. I am not sure what is wrong

this method works for the Spec limits but does not show the control limits. I am not sure what is wrong

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

I was going to comment on your "Show Limits()" element you added to the Control Limits specification. As far as I know, Spec Limits and Response are the only limits that will automatically display on charts and graphs.

Control limits can be set for different phases in the data table. The Control Chart Platforms can handle the phases and the displaying of control limits. Once you go outside of the Control Limits Platforms, the displaying of control limits has to be done by adding JSL to the charts to display the limits.

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

sorry Jim, I think I am confused with your answer,

I added

Eval(

Substitute(

Expr(

:REM OX << Set Property(

"Control Limits",

{XBar( Ave( __avg__ ), LCL( __LCL__ ), UCL( __UCL__ ) ),

Show Control Limits( 1 )}

)

),

Expr( __avg__ ), :Center Line[1],

Expr( __LCL__ ), :Lower Limit[1],

Expr( __UCL__ ), :Upper Limit[1],

),

);

to my script to upload the limits.

It does not show any thing on the charts. It is working for Spec limits.

I could not understand your comment about Show Control limits()

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: how to set the control limit for a column using other columns?

As I stated in my last response:

As far as I know, Spec Limits and Response are the only limits that will automatically display on charts and graphs

Control Limits do not have the capability to automatically be displayed on charts, except for Control Charts!

As far as I know, Spec Limits and Response are the only limits that will automatically display on charts and graphs

Control Limits do not have the capability to automatically be displayed on charts, except for Control Charts!

Jim