Subscribe Bookmark RSS Feed

How to plot variability chart using data filter ?

kaushik_pushpen

Community Trekker

Joined:

Feb 22, 2015

Hello everyone,

I have one Abc.jmp table in which i am  using data filtering one by one by selecting value from the table Layer.jmp. So, after data filtering i want to plot various variabilty chart. But it is not happening. Script is as follows:


dt1 = open("F:\Abc.jmp");

dt2 = open("F:\Layer.jmp");

for(i=1, i<=nrow(dt2), i++,

     df = dt1<< Data Filter(

       Add Filter(

       columns( :Mask ),

       Where(:Mask == Eval((trim(column(dt2, 1))))),

       Display(:ParameterId, Size( 221, 259 ), List Display )

       ), make subset

     );

          df<<Variability Chart(

            Y( :Name( "CD-value" ) ),

            X( :Axis ),

            Analysis Type( Name( "Choose best analysis (EMS REML Bayesian)" ) ),

            Process Variation( 0 ),

            Show Grand Mean( 1 ),

            Std Dev Chart( 0 ),

            By(:Nominal)

            )

);

Please give your valuable suggestion.

Thanks in advance.

1 REPLY
ms

Super User

Joined:

Jun 23, 2011

I think you'd want the index to be right after Column(), i.e. inside Trim(), not outside.

...,

Where(:Mask == Eval(trim(column(dt2, 1)[i]))),

...