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
shampton82
Level VII

Filter Col Selector usage

I'm trying to use a Filter Col Selector but I can't get it to return the selected value.

 

names default to here(1);

dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" );

nw=new window("test", <<modal, <<return result,
			v list box(var1=Filter Col Selector(dt),
			H List Box( Button Box( "OK" ), Button Box( "Cancel" ) ))
	
	
);

In this example var1 doesn't return the column name that was selected.

Thanks for any direction on how to use this!

 

Steve

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Filter Col Selector usage

Here is one way to capture the value of the Filter Selector

names default to here(1);

dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" );

nw=new window("test", <<modal, <<return result,
			v list box(var1=Filter Col Selector(dt),
			H List Box( Button Box( "OK" ), Button Box( "Cancel" ) )),
			var1<<set script(zippy=var1<<get selected);
	);

 The variable zippy contains the selected values

Jim

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: Filter Col Selector usage

Here is one way to capture the value of the Filter Selector

names default to here(1);

dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" );

nw=new window("test", <<modal, <<return result,
			v list box(var1=Filter Col Selector(dt),
			H List Box( Button Box( "OK" ), Button Box( "Cancel" ) )),
			var1<<set script(zippy=var1<<get selected);
	);

 The variable zippy contains the selected values

Jim
shampton82
Level VII

Re: Filter Col Selector usage

Thanks Jim!

I just noticed that the column list box that shows up does not default with the filter on, is there a way to have this option be turned on by the script vs using the red triangle?

txnelson
Super User

Re: Filter Col Selector usage

I don't see a message that will turn the filter on, but I did not do a real exhaustive search. Take a look in the Scripting Index under the FilterColSelector and maybe you can find such.
Jim