cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
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) ));