441050_en-US

liliconcom

Issues with recognizing an argument in the script

Hi,

Can someone please have a look at my script and give me an idea what I'm doing wrong.

Trying to select and argument using comb box which ten is incorporated into the column name and based on that column im trying to generate control chart using the adjusted column name but it doesn't work.

 

Names Default To Here( 1 );
New Window( "Data selection",
    <<MODAL></MODAL>

 

Thanks,

Tomasz

ScriptingRe: Issues with recognizing an argument in the script

Hi @swiergi11 ,

 

  I think one of the problems is how you reference the column in the Chart Col() part of the Control Chart(). The problem is that it's not evaluating the :"RSM_"||level as a column, just the :"RSM_" part and so it doesn't know what to do with the ||layer concatenation.

 

  As a workaround, you can evaluate the concatenation before you call the Control Chart with something like:   Ycol="RSM_"||layer; then, instead of :"RSM_"||layer as the Chart Col(), use: Cart Col( As Column(Ycol) ), and you'll be able to run the script as you expect.

 

  Here's the modified code below:

Names Default To Here( 1 );
New Window( "Data selection",
      <<MODAL></MODAL>

Hope this helps!,

DS

  

Re: Issues with recognizing an argument in the script

 Very Nice, thanks a lot. 

I can generate control charts but for some reason cannot follow through with statistic, seems like second part of the control chart script has still problem.

Tried to get another argument but no luck. 

 

Names Default To Here( 1 );
New Window( "Data selection",
 <<MODAL></MODAL>

 

I hope to see the report as below:

 

 

Re: Issues with recognizing an argument in the script

Hi @swiergi11 ,

 

  Not sure why your existing code doesn't work. I tried something similar in the sense of wanting to have the capability analysis as part of the call within the Control Chart() call, but it doesn't "activate" it. There is another work around that you can send the command to the "object" that is the control chart and have it perform the analysis.

 

  Also, you'll probably want to include the LSL, USL, and Target as column properties so that it automatically performs the correct analysis. You need to assign them using the <

 

Hope this helps!,

DS

Names Default To Here( 1 );
New Window( "Data selection",
 <<MODAL></MODAL>

Re: Issues with recognizing an argument in the script

Dear @swiergi11 ,

my experience is that sometimes variable replacement in messages works and sometimes not. So what you can help here is building an expression, replace variables, and then excute the expression. 

This works for the simplified example below similar to your task.

BR

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

Ycol = "weight";
Xcal = "height";

cc_expr = Expr(
 dt << Control Chart(
  Sample Label( :name ),
  KSigma( 3 ),
  Chart Col(
   Expr( column(Ycol) ),
   Levey Jennings( Show Zones( 1 ), Shade Zones( 1 ), Test 1( 1 ), Test 2( 1 ), Test 5( 1 ), Test 6( 1 ), Test Beyond Limits( 1 ) ),
   Capability(
    Distribution(
     Continuous Distribution(
      Column( Expr(Xcal ) ),
      Quantiles( 0 ),
      Summary Statistics( 0 ),
      Outlier Box Plot( 0 ),
      Normal Quantile Plot( 1 ),
      Capability Analysis( LSL( 90 ), USL( 110 ), Target( 105 ), Sigma( 22.2018710230259 ), Shewhart )
     )
    )
   )
  )
 )
);

eval(Eval Expr( cc_expr ));

Re: Issues with recognizing an argument in the script

thanks a lot Georg and DS, works well now. 

 

Both above solutions works.