cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
Rajat
Level IV

How to add a Filter column button in a column dialog box.

I have made a column dialog, in which I will select the 6 columns from all the columns. As number of columns are very large, so its very painful to look for the required column. So, I want to add a filter column button the Column Dialog window. How to add it? Below is my script for column dialog. Inside this window I want to add the filter column option.

Thanks.

dlg = Column Dialog(


A = ColList( "Time", Max Col( 1 ), Min Col( 1 ) ),
B = ColList( "Step", Max Col( 1 ), Min Col( 1 ) ),
c = ColList( "Tool", Max Col( 1 ), Min Col( 1 ) ),
D = ColList( "Name", Max Col( 1 ), Min Col( 1 ) ),
E = ColList( "Lot", Max Col( 1 ), Min Col( 1 ) ),
F = ColList( "Number", Max Col( 1 ), Min Col( 1 ) ),
G = ColList( "Run", Max Col( 1 ), Min Col( 1 ))
);

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How to add a Filter column button in a column dialog box.

What version of JMP are you using?  The filter was added to JMP 14.

If you have an earlier release you will have to build the filter yourself.  There is code you can copy from an Addin that I uploaded to the JMP File Exchange.  It is called

Runs Test (Wald-Wolfowitz Test) and JSL Implementation of JMP Platform Dialog Box

Jim

View solution in original post

4 REPLIES 4
txnelson
Super User

Re: How to add a Filter column button in a column dialog box.

The Column Dialog() object automatically creates a column list with a filter.  Below is the example taken directly from the Scripting Index 

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Consumer Preferences.jmp" );
Column Dialog(
	ex y = ColList( "Y",
		Min Col( 1 ),
		Max Col( 2 ),
		Data Type( "Numeric" )
	),
	ex x = ColList( "X",
		Max Col( 1 ),
		Modeling Type(
			{"Continuous", "Multiple Response"}
		)
	),
	Line Up( 2,
		Text Box( "Alpha" ), ex = EditNumber( .05 ),
		Text Box( "Beta" ), ey = EditText( "xyz" )
	),
	HList( cb = Check Box( "check", 1 ) ),
	HList(
		combo = Combo Box( "option1", "option2" )
	),
	HList( rb = RadioButtons( "a", "b" ) )
);

dialog.PNG

Jim
Rajat
Level IV

Re: How to add a Filter column button in a column dialog box.

If I run the code mentioned in the problem, it only shows the list of columns and variables that I have to select. Can it be like, it shows a search button, where I can type required column name and it will filter out the column list containing that name.
txnelson
Super User

Re: How to add a Filter column button in a column dialog box.

What version of JMP are you using?  The filter was added to JMP 14.

If you have an earlier release you will have to build the filter yourself.  There is code you can copy from an Addin that I uploaded to the JMP File Exchange.  It is called

Runs Test (Wald-Wolfowitz Test) and JSL Implementation of JMP Platform Dialog Box

Jim
Rajat
Level IV

Re: How to add a Filter column button in a column dialog box.

Thanks txnelson filter option shows in JMP14. Appreciate your help.
Do you know any command so, filter option get showed automatically in the column dialog.