cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

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%3ENo%20se%20puede%20establecer%20el%20atributo%20de%20l%C3%ADmite%20de%20especificaci%C3%B3n%20(USL%2FLSL)%20para%20cada%20columna%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%20Tabla%20de%20datos%20actual()%3B%3C%2FP%3E%3CP%3Edt%20%26lt%3B%26lt%3B%20Iniciar%20actualizaci%C3%B3n%20de%20datos()%3B%3CBR%20%2F%3E%20Para%20(i%20%3D%209%2C%20i%20%26lt%3B%3D%20N%20columnas%20(dt)%20-%201%2C%20i%2B%2B%2C%3CBR%20%2F%3E%20col%20%3D%20Columna(%20dt%2C%20i%20)%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%20%2F%2F%20Obtener%20la%20segunda%20y%20tercera%20fila%20de%20datos%20como%20l%C3%ADmites%20de%20especificaci%C3%B3n%3CBR%20%2F%3E%20l%C3%ADmiteinferior%20%3D%20col%5B2%5D%3B%3CBR%20%2F%3E%20l%C3%ADmitesuperior%20%3D%20col%5B3%5D%3B%3CBR%20%2F%3E%20mostrar%20(l%C3%ADmite%20inferior)%3B%3CBR%20%2F%3E%20show(upperLimit)%3B%20%2F%2F%20%3CSTRONG%3Erevis%C3%A9%20el%20registro%2C%20el%20resultado%20es%20correcto.%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%2F%2FEstablecer%20atributos%20de%20l%C3%ADmite%20de%20especificaci%C3%B3n%3CBR%20%2F%3E%20col%20%26lt%3B%26lt%3B%20Establecer%20propiedad%20(%22L%C3%ADmites%20de%20especificaci%C3%B3n%22%2C%20%7BLSL%20(l%C3%ADmite%20inferior)%2C%20USL%20(l%C3%ADmite%20superior)%2C%20Mostrar%20l%C3%ADmites%20(1)%7D)%3B%3CBR%20%2F%3E%20)%3B%3CBR%20%2F%3E%20dt%20%26lt%3B%26lt%3B%20Finalizar%20actualizaci%C3%B3n%20de%20datos()%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%3EAn%C3%A1lisis%20y%20modelado%20de%20datos%20b%C3%A1sicos%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%3ERe%3A%20No%20se%20puede%20establecer%20el%20atributo%20de%20l%C3%ADmite%20de%20especificaci%C3%B3n%20(USL%2FLSL)%20para%20cada%20columna%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738256%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ETendr%C3%A1s%20que%20evaluar%20los%20valores%20de%20las%20columnas%2C%20a%20continuaci%C3%B3n%20se%20muestra%20un%20ejemplo.%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%3EInserte%20una%20expresi%C3%B3n%20en%20otra%20usando%20Eval%20Insert%2C%20Eval%20Expr%2C%20Parse%20y%20Substitute%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