How to set the response limits using a variable in a JMP script

[#1]

Hello,

I would like to use a JMP script to automatically set the desirability for a JMP column, based on the statistics of the column itself. I would like to do this because I have multiple metrics and I would like to combine them in a single desirability metric using the JMP profiler platform. I am a JMP 16.1 user.

Unfortunately the following code does not work - the response limits are set but the value is missing:

median = Col Quantile( :"A", 0.5);
limit1 = Col Quantile( :"A", 0.95);
limit2 = Col Quantile( :"A", 0.05);

low_limit = if(limit1<limit2, limit1, limit2);
upper_limit = if(limit1>limit2, limit1, limit2);

Data Table( "TS_Table" ):"A"n <<
Set Property(
	"Response Limits",
	{Goal( Maximize ), Lower( low_limit, 0.05 ), Middle( median, 1 ),
	Upper( up_limit, 0.05 ), Importance( 2 ), Show Limits( 1 )}
);

If I replace the variables with the an actual value, the setting of the response limits works fine.

Am I doing something wrong when I evaluate the variables in the set Property function?

Thanks in advance for the help

Davide

[#2 · Accepted solution]

Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute will most likely be able to help you with this. 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");

low_limit = 50;
high_limit = 100;

Eval(Eval Expr(Column(dt, "height") << Set Property(
	"Response Limits",
	{Goal(Maximize), Lower(Expr(low_limit), 0.05), Middle(median, 1), Upper(Expr(high_limit), 0.05), Importance(2),
	Show Limits(1)}
)));

[#3]

Perfect, thank you for your help!

[#4]

The desirability values in this example appear to be for matching a target response, not maximizing a response.

[#5]

Thank you for pointing that out, Mark