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; } } }

Script For Adding Spec Limits to a column

ar2

I am new to scripting

I am sure this is very straightforward, but I am looking to create a script that adds an upper spec limit to a column (No USL or Target required)

Many thanks for any guidance

Accepted answers

ian_jmp

Here's one way:

NamesDefaultToHere(1);

// ******************************************************************************************
// Given a column reference, sets spec liomits property
// ******************************************************************************************
SetSpecLimits = function({c, lsl, usl, tar},
     cmd = Expr(c << SetProperty("Spec Limits", {LSL(expr(lsl)), USL(expr(usl)), Target(expr(tar))}));
     eval(evalexpr(cmd));
);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
SetSpecLimits(Column(dt, "height"), 60, ., .);		// Set LSL only
SetSpecLimits(Column(dt, "weight"), 80, 120, 100);	// Set all three values

Use 'Help > Scripting INdex' and 'Help > Books > Scripting Guide' to help figure out how it works.

All comments

ian_jmp

Here's one way:

NamesDefaultToHere(1);

// ******************************************************************************************
// Given a column reference, sets spec liomits property
// ******************************************************************************************
SetSpecLimits = function({c, lsl, usl, tar},
     cmd = Expr(c << SetProperty("Spec Limits", {LSL(expr(lsl)), USL(expr(usl)), Target(expr(tar))}));
     eval(evalexpr(cmd));
);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
SetSpecLimits(Column(dt, "height"), 60, ., .);		// Set LSL only
SetSpecLimits(Column(dt, "weight"), 80, 120, 100);	// Set all three values

Use 'Help > Scripting INdex' and 'Help > Books > Scripting Guide' to help figure out how it works.

ar2

Thanks Ian...I'll give it a go

Andrew

deveshchugh

Hi Ian,

Is there a way to add LSL/USL based on grouping by a second column. For ex: have different LSL/USL based on whether student is boy or girl. So, when we plot weight age/weight by either boy or girl, the corresponding limits should be displayed on chart (LSL/USL only). if we plot the boy and girl height in one plot, the limit label could add _"groupby name" to the limit (ex: LSL_boy, USL_boy, LSL_girl, USL_girl).

Thanks,

Devesh

deveshchugh

Also, is there a way to rename to either LSL/USL to display some other name?

txnelson

You can not change the LSL and USL labels. You can load the limits as Response Limits, and it will label them RSL and LSL. Finally, you can add you own Reference Lines which will allow you to name them whatever you want.