nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Mikasa

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

Accepted answers

All comments

statman

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?

Mikasa

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.

statman

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

Mikasa

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

txnelson

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]
	)
);

Mikasa

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

txnelson

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.

Mikasa

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()