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.
Second filter with !=NA does not work
Re: Second filter with !=NA does not work
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
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
Re: Second filter with !=NA does not work
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!
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!
Re: Second filter with !=NA does not work
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.
- Attachments
-
- filterfilterPicture4.png (115.32 KiB) Viewed 2077 times
Re: Second filter with !=NA does not work
if you could create an issue over at https://github.com/jamovi/jamovi/issues that would be great.
with thanks
with thanks
Re: Second filter with !=NA does not work
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
@jonathon I have created the issue as wanted.
Best