Filtering base on participants response

General help and assistance with jamovi. Bug reports can be made at our issues page: . (If you're unsure feel free to discuss it here)

by ds081227 » Sat Nov 09, 2019 12:31 pm

Hi I am an undergraduate student working on a pre-registered report for a replication project. I would like to ask if there are any functions in Jamovi to filter data based on the participants' responses in another question. I watched some guides that guide me towards the computing variable function but I am not sure how should I set it up.
In my case, we have a question asking about their amount of optimism (on a -5 to +5 scale) towards the event 'marrying someone wealthy'. We also have an exclusion question asking participants their marital status with 1=single, 2=married, 3=divorced, 4=other/would rather not disclose. We would like to exclude participants' response who answered married and other/would rather not disclose from the above event, and analyze it with other data. How should I set up the compute variable? I have tried setting up with FILTER(MaritalStatus !=2, MaritalStatus !=4) but it doesn't seem to work this way. We also tried that the filtering function but it filters married participants for all questions which we only want to filter on one question. Thank you!
Posts: 1
Joined: Sat Nov 09, 2019 9:28 am

by MAgojam » Sat Nov 09, 2019 4:42 pm

Hi, @ds081227.

You should use the Filter function like this:
FILTER(MaritalStatus, MaritalStatus != 2 and MaritalStatus != 4)

User avatar
Posts: 74
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

by jonathon » Mon Nov 11, 2019 1:01 am

maurizio is right, but if you use a row filter, you don't need to use the `FILTER()` function at all:

Screen Shot 2019-11-11 at 12.00.38.png
Screen Shot 2019-11-11 at 12.00.38.png (458.66 KiB) Viewed 488 times
User avatar
Posts: 1270
Joined: Fri Jan 27, 2017 10:04 am

Return to Help