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

data filters, new option: "not"

☑ cool new feature
☐ could help many users!

☐ removes a „bug“

☐ nice to have

☐ nobody needs it

 

#myTop10_2022

 

 

If a column is set to "multiple response", there are cool options available in the data filter menu:

hogi_0-1668761413650.png

These allow the user to get much more power out of the data filter. Most of them rely on the fact that there are "multiple responses" in the column - and the user can select which combination he wants.

There is also an option "none". It has the same effect as the "inverse" - but the difference is that "inverse" just inverts the current selection, but "none" is a setting which is applied in the background.

With "none" fancy Data filters are possible along the idea: THIS, but not THAT:

https://community.jmp.com/t5/Discussions/Conditional-Data-Filter-for-modeling-type-Multiple-Response...

 

Unfortunately, for standard columns, there is no "none":

https://community.jmp.com/t5/Discussions/advanced-data-filter-arithmetic-just-available-if-the-colum...

 

Every Jmp user who worked with the cool functionalities of multiple response columns (esp. the availability of "not") feels an incredible lack of functionality when working with standard columns.

 

my wish:

Add "not" also for standard data filters.

 

 

more wishes submitted by  hogi_2-1702196401638.png

13 Comments
hogi
Level XII

Oh, it seems that Inverse doesn't solve the problem that the entries are removed from the source script if they are not inside the current data table.
(the issue from the referenced discussion was not stated clearly in my previous post - so I added "persistent")

 

I just tried the steps in 
https://community.jmp.com/t5/Discussions/Data-filter-how-to-specify-the-limits/m-p/643556/highlight/... 

 

with your code with Jmp 17.1 - and after saving the script, 

Where( :name == {"CHRIS", "DAVID", "KATIE2", "ANOTHER NAME", "SOMEONE ELSE"} ),

was gone.

julian
Community Manager

You're quite right, @hogi! I didn't dig deep enough into the question to give a useful answer here. I can't think of a way to accomplish this with the existing tools, so it's good you got this on the wish list.

hogi
Level XII

yes, it will be sooo useful!

I hope it will be implemented in one of the future releases of JMP ...