Script For Adding Spec Limits to a column

[#1]

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

[#2 · Accepted solution]

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.

[#3]

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

Andrew

[#4]

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

[#5]

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

[#6]

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.