Excluding multiple rows with one filter

General help and assistance with jamovi. Bug reports can be made at our issues page: https://github.com/jamovi/jamovi/issues . (If you're unsure feel free to discuss it here)
Post Reply
Brenna
Posts: 5
Joined: Mon Sep 16, 2019 8:39 am

Excluding multiple rows with one filter

Post by Brenna »

Im loving using Jamovi for my first year doing research. Its awesome!
Is it possible to exclude multiple rows using a single filter? I can exclude them one by one. Have tried a few other ways like using != or < or > but I cant figure it out.
dropmann
Posts: 79
Joined: Thu Feb 02, 2017 10:26 am

Re: Excluding multiple rows with one filter

Post by dropmann »

Hi Brenna,

Could you give an example of what you have tried? I don't seem to have any trouble filtering out multiple rows.
User avatar
MAgojam
Posts: 421
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

Re: Excluding multiple rows with one filter

Post by MAgojam »

Hi, Brenna.
Maybe I didn't understand your request, but as an example I enclose this screenshot where I applied a single filter, with multiple variables, to the iris data in the library.
ScreenShot_FILTER.png
ScreenShot_FILTER.png (79.2 KiB) Viewed 9667 times
Cheers.
Maurizio
Brenna
Posts: 5
Joined: Mon Sep 16, 2019 8:39 am

Re: Excluding multiple rows with one filter

Post by Brenna »

I am wanting to exclude the particpants who did not complete the survey, using the finished or progress column. Previously I have used ROW() != to exclude a single row. <br />I will try what you have done MAgojam thank you
I am wanting to exclude the particpants who did not complete the survey, using the finished or progress column. Previously I have used ROW() != to exclude a single row.
I will try what you have done MAgojam thank you
2019-10-09.png (148.69 KiB) Viewed 9665 times
User avatar
MAgojam
Posts: 421
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

Re: Excluding multiple rows with one filter

Post by MAgojam »

Brenna wrote: I am wanting to exclude the particpants who did not complete the survey, using the finished or progress column.
Hi, Brenna.
Maybe this suggestion might be useful?

Cheers.
Maurizio
Attachments
ScreenShot_FILTER2.png
ScreenShot_FILTER2.png (54.51 KiB) Viewed 9663 times
User avatar
jonathon
Posts: 2613
Joined: Fri Jan 27, 2017 10:04 am

Re: Excluding multiple rows with one filter

Post by jonathon »

hey,

i've just taken a look at this, and i'm a bit surprised it's not as straight-forward as i thought it would be.

looks like maurizio's suggestion is probably the best for the time being.

of you could use the formula:

1A != NA and 2A != NA and 3A != NA

NA is a special value signifying a 'missing value'. as a general rule, missing values, the way they're used in statistics, are confusing. i'll have a think about how we can make this more straight-forward.

cheers and thanks for bringing this up.

jonathon
Brenna
Posts: 5
Joined: Mon Sep 16, 2019 8:39 am

Re: Excluding multiple rows with one filter

Post by Brenna »

Thank you Maurizio, I will try that. I really appreciate everyone's input :slightly_smiling_face:
adaren
Posts: 20
Joined: Tue Jan 03, 2023 12:25 pm

Re: Excluding multiple rows with one filter

Post by adaren »

Is there a method to filter multiple rows by number with one filter?
e.g.
ROW()!=25 works fine, but if you want to filter out many rows, can you do this in one filter? (e.g. ROW()!=c(25, 35, 33, 53, 23) does not work..)

I only know that separate filters for every value work - cannot find shorter method..
User avatar
reason180
Posts: 274
Joined: Mon Jul 24, 2017 4:56 pm

Re: Excluding multiple rows with one filter

Post by reason180 »

To add to the examples provided earlier in this thread, the following filters-out Rows 2, 5, and 7:

ROW()!=2 and ROW()!=5 and ROW()!=7
User avatar
reason180
Posts: 274
Joined: Mon Jul 24, 2017 4:56 pm

Re: Excluding multiple rows with one filter

Post by reason180 »

Here's another example. It filters-out Row 2 ad Rows 5 through 7.

Code: Select all

not(ROW()==2) and not(ROW()>= 5 and ROW()<=7)
Post Reply