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

hogi — Sat, 10 Jun 2023 23:55:22 GMT

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 ...

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

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

hogi — Fri, 18 Nov 2022 09:10:55 GMT

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

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

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

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