jamovi

Hi everyone,

I have a problem filtering missing values. To show you, I made an example data spreadsheet in jamovi. In this data set I have two variables, A and B with some missing values. If I filter them like this, it works:

Filter 1: A !=NA
Filter 2: B !=2
But what I want to do is filter missing values of variable A in the first filter and missing values of variable B in the second filter, like this:

Filter 1: A !=NA
Filter 2: B !=NA

But then filter 2 is not working.

Can someone explain to me why that is and how I could fix it?

Of course, there is the option to put the first filter like this:
Filter 1: A !=NA
and B !=NA

Then it works! But because I have a more complex case in real life, where I need the option to put the filter on and off seperataly, this sadly isn't an option for me.

Thank you very much for your help and any ideas on how to fix this.

Hey @jachmovi,
maybe this tip (screenshot) could help you.

It is a listwise filter for the missing with the variables of interest.
Quick and easy to add or remove variables. Cheers,
Maurizio

Hey Maurizio,
thank you so much, this helps a lot! 
So instead of 
Filter 1: A != NA
Filter 2: B != NA
I just wrote
Filter 1: IF (A)
Filter 2: IF (B)
and it works just as I wanted it to.
I still don't get why the first way doesn't work, but the problem is solved.
Thanks again, you saved my day!

It seems to me that there's something wrong with how jamovi handles filtering that references NA. Below, the top screenshot shows an improper result when NA is referenced, but the bottom screenshot shows a correct result when a different approach is taken--one that does not reference NA.

if you could create an issue over at https://github.com/jamovi/jamovi/issues that would be great.

with thanks

Thank you @reason180, for replicating this issue and showing another alternative way to get the desired outcome.

@jonathon I have created the issue as wanted.

Best