612873_en-US

liliconcom

Data filter for drop down box

Hi, all. There might be similar questions here,  but I didn't find one that solves my problem.

On the dashboard, I made inputs into a drop down box. i want the output table to change when I select different inputs. 

What functions should I use and is there a sample somewhere?

Thank you so much!

Mass CustomizationRe: Data filter for drop down box

You can use the << Set function. Please refer to the following page.

https://community.jmp.com/t5/JMP-Knowledge-Base/How-to-dynamically-populate-a-ComboBox-based-upon-user-selection/ta-p/575407 

Here is an example.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

make_tabulate_script = Function( {col},
 tablate_script = Parse(
  Eval Insert(
   "dt << Tabulate(
  Show Control Panel( 0 ),
  Add Table(
   Column Table( Analysis Columns( ^col^ ), Statistics( Mean ) ),
   Row Table( Grouping Columns( :sex ) )
  )
 )"
  )
 );
 Eval Expr( tablate_script );
);

tablate_script = make_tabulate_script( ":height" );

nw = New Window( "new window",
 vb1 = H List Box(
  V List Box(
   Text Box( "Please Slect" ),
   cb = Combo Box(
    {":height", ":weight"},
    <<SET function=""></SET>