cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
antoinesofradir
Level III

How to use a value selected in a list ?

Hi, i selected a value in a list thanks to a window, this value is keep in a variable.

i would like now to select the lines in my data table which correspond to this value, how can i do ?

here my script :

value = {"1","2","3","4"};

New Window( "window",
Outline Box( "example",
  H List Box( Text Box( "select value" ), listvalues= list Box(value, nlines(4))),
  Button Box( "OK",
    value = (listvalues << Get selected);
    nw << Close Window;)
)
);


dt << Select Where(variable== value);

thanks for your help !

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to use a value selected in a list ?

Value will be a List of strings. Char must be used if variable is numeric.

If only one item is to be selected selected, this should work:

dt << Select Where(contains(char(variable)==value[1] ));

The below works also if several items are selected:

dt << Select Where(contains(value, char(variable) ));

View solution in original post

1 REPLY 1
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to use a value selected in a list ?

Value will be a List of strings. Char must be used if variable is numeric.

If only one item is to be selected selected, this should work:

dt << Select Where(contains(char(variable)==value[1] ));

The below works also if several items are selected:

dt << Select Where(contains(value, char(variable) ));