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

Question

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

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/m-p/556062#M77004)

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... (Highlight to read)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( "" ) ) )
	)
);

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( "" ) ) )
	)
);

hogi · Answer

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

Accepted answers

All comments

Quick Links