cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hogi
Level XI

advanced data filter arithmetics - just available if the column is "multiple response"?

Try a data filter with a column which is set to "multiple response".
Then the red triangle menu provides a large list of options:

HolgerSp_0-1665922119825.png

There is even a "none" in the list, which makes it possible to select 

 

THIS, but not THAT :
(https://community.jmp.com/t5/Discussions/Conditional-Data-Filter-for-modeling-type-Multiple-Response...)

hogi_0-1666105433847.png

 

Now the question:

For columns which are non-multiple-response, is it possible to set up such negative selections as well?
I mean: directly via the data filter logics, not via select and invert.
Just putting the "Match none" around a standard filter did not work ...

 

If this is not possible yet for standard coulumns, I will write a wish ...
it's so useful to have the possibility to negate selections  ...

View more...
Open( "$SAMPLE_STIPS/Wafer Stacked Small.jmp" );
Data Table( "Wafer Stacked Small" ):Lot_Wafer Label <<
Set Modeling Type( "Multiple Response" );

Graph Builder(
	Size( 487, 504 ),
	Show Control Panel( 0 ),
	Graph Spacing( 5 ),
	Variables(
		X( :X_Die ),
		Y( :Y_Die ),
		Wrap( :Lot_Wafer Label ),
		Overlay( :Defects )
	),
	Elements( Points( X, Y, Legend( 17 ) ) )
);

wait(1);

Current Data Table() << Data Filter(
	Location( {670, 124} ),
	Mode( Include( 1 ) ),
	Add Filter(
		columns( :Lot, :Lot_Wafer Label ),
		Where( :Lot == "4" ),
		Match None( Where( :Lot_Wafer Label == {"4_1", "4_4"} ) ),
		Display( :Lot, N Items( 5 ) ),
		Display( :Lot_Wafer Label, Find( Set Text( "" ) ) )
	)
);


 

1 REPLY 1
hogi
Level XI

Re: advanced data filter arithmetics - just available if the column is "multiple response"?

For "multiple response" there is no problem to add the column twice to the data filter.
For standard columns, JMP will just refuse to add another copy.

But one can enable "grouped by and" to get the same column twice

So, what's missing to get THIS, but not THAT data filters for standard columns:

 

The  option "none". Here is the wish:
https://community.jmp.com/t5/JMP-Wish-List/data-filters-new-option-quot-none-quot/idi-p/570904 

 

hogi_0-1668762323095.png