cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-738232%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E6%97%A0%E6%B3%95%E4%B8%BA%E6%AF%8F%E5%88%97%E8%AE%BE%E7%BD%AE%E8%A7%84%E6%A0%BC%E9%99%90%E5%B1%9E%E6%80%A7%20(USL%2FLSL)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738232%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3Edt%20%3D%20%E5%BD%93%E5%89%8D%E6%95%B0%E6%8D%AE%E8%A1%A8()%3B%3C%2FP%3E%3CP%3Edt%20%26lt%3B%26lt%3B%20Begin%20Data%20Update()%3B%3CBR%20%2F%3EFor(%20i%20%3D%209%2C%20i%20%26lt%3B%3D%20N%20Cols(%20dt%20)%20-%201%2C%20i%2B%2B%2C%3CBR%20%2F%3Ecol%20%3D%20Column(%20dt%2C%20i%20)%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%2F%2F%20%E8%8E%B7%E5%8F%96%E7%AC%AC%E4%BA%8C%E8%A1%8C%E5%92%8C%E7%AC%AC%E4%B8%89%E8%A1%8C%E7%9A%84%E6%95%B0%E6%8D%AE%E4%BD%9C%E4%B8%BA%E8%A7%84%E6%A0%BC%E9%99%90%3CBR%20%2F%3ElowerLimit%20%3D%20col%5B2%5D%3B%3CBR%20%2F%3EupperLimit%20%3D%20col%5B3%5D%3B%3CBR%20%2F%3Eshow%20(lowerLimit)%3B%3CBR%20%2F%3Eshow(upperLimit)%3B%20%2F%2F%3CSTRONG%3E%20checked%20the%20log%2C%20the%20result%20is%20ok.%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%2F%2F%20%E8%AE%BE%E7%BD%AE%E8%A7%84%E6%A0%BC%E9%99%90%E5%B1%9E%E6%80%A7%3CBR%20%2F%3Ecol%20%26lt%3B%26lt%3B%20Set%20Property(%20%22Spec%20Limits%22%2C%20%7BLSL(lowerLimit)%2C%20USL(upperLimit)%2C%20Show%20Limits(%201%20)%7D%20)%3B%20%3CBR%20%2F%3E)%3B%3CBR%20%2F%3Edt%20%26lt%3B%26lt%3B%20End%20Data%20Update()%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ryan001_0-1711204403209.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ryan001_0-1711204403209.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ryan001_0-1711204403209.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62552i6E45F17D434FC186%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ryan001_0-1711204403209.png%22%20alt%3D%22Ryan001_0-1711204403209.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ryan001_1-1711204413014.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ryan001_1-1711204413014.png%22%20style%3D%22width%3A%20276px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ryan001_1-1711204413014.png%22%20style%3D%22width%3A%20276px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62553i59313F5BB3BFA092%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ryan001_1-1711204413014.png%22%20alt%3D%22Ryan001_1-1711204413014.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ryan001_2-1711204423440.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ryan001_2-1711204423440.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ryan001_2-1711204423440.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62554i1A4E9FC948555118%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ryan001_2-1711204423440.png%22%20alt%3D%22Ryan001_2-1711204423440.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ryan001_3-1711204429136.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ryan001_3-1711204429136.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Ryan001_3-1711204429136.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62555i1756A972468B852B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ryan001_3-1711204429136.png%22%20alt%3D%22Ryan001_3-1711204429136.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738232%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%E5%9F%BA%E7%A1%80%E6%95%B0%E6%8D%AE%E5%88%86%E6%9E%90%E5%92%8C%E5%BB%BA%E6%A8%A1%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738256%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E6%97%A0%E6%B3%95%E4%B8%BA%E6%AF%8F%E5%88%97%E8%AE%BE%E7%BD%AE%E8%A7%84%E6%A0%BC%E9%99%90%E5%B1%9E%E6%80%A7%20(USL%2FLSL)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738256%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%82%A8%E5%BF%85%E9%A1%BB%E8%AF%84%E4%BC%B0%E5%88%97%E7%9A%84%E5%80%BC%EF%BC%8C%E4%B8%8B%E9%9D%A2%E6%98%AF%E4%B8%80%E4%B8%AA%E7%A4%BA%E4%BE%8B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%20%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0A%0Alowlimit%20%3D%2050%3B%0Ahighlimit%20%3D%20100%3B%0A%0AEval(EvalExpr(%0A%09Column(dt%2C%20%22height%22)%20%26lt%3B%26lt%3B%20Set%20Property(%0A%09%09%22Spec%20Limits%22%2C%0A%09%09%7BLSL(Expr(lowlimit))%2C%20USL(Expr(highlimit))%2C%20Show%20Limits(1)%7D%0A%09)%3B%09%0A))%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJSL-Cookbook-Archived%2FInsert-one-expression-into-another-using-Eval-Insert-Eval-Expr%2Fm-p%2F48998%23U48998%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-tkb-thread%20lia-fa-icon%20lia-fa-tkb%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%E4%BD%BF%E7%94%A8%20Eval%20Insert%E3%80%81Eval%20Expr%E3%80%81Parse%20%E5%92%8C%20Substitute%20%E5%B0%86%E4%B8%80%E4%B8%AA%E8%A1%A8%E8%BE%BE%E5%BC%8F%E6%8F%92%E5%85%A5%E5%8F%A6%E4%B8%80%E4%B8%AA%E8%A1%A8%E8%BE%BE%E5%BC%8F%3C%2FA%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

Recommended Articles