cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Ryan001
Level I

Cannot set the specification limit attribute (USL/LSL) for each column

dt = Current Data Table();

dt << Begin Data Update();
For( i = 9, i <= N Cols( dt ) - 1, i++,
col = Column( dt, i );

// 获取第二行和第三行的数据作为规格限
lowerLimit = col[2];
upperLimit = col[3];
show (lowerLimit);
show(upperLimit); // checked the log, the result is ok.

// 设置规格限属性
col << Set Property( "Spec Limits", {LSL(lowerLimit), USL(upperLimit), Show Limits( 1 )} ); 
);
dt << End Data Update();

Ryan001_0-1711204403209.png

Ryan001_1-1711204413014.png

 

Ryan001_2-1711204423440.png

Ryan001_3-1711204429136.png

 

 

1 REPLY 1
jthi
Super User

Re: Cannot set the specification limit attribute (USL/LSL) for each column

You will have to evaluate the values to columns, below is an example

Names Default To Here(1); 

dt = Open("$SAMPLE_DATA/Big Class.jmp");

lowlimit = 50;
highlimit = 100;

Eval(EvalExpr(
	Column(dt, "height") << Set Property(
		"Spec Limits",
		{LSL(Expr(lowlimit)), USL(Expr(highlimit)), Show Limits(1)}
	);	
));

Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute 

-Jarmo