I have a survey that's fielding with commercial sample, and based on reviewing open end responses, I have 50+ respondents that are fraudulent / not giving good responses, and I want to set a flag to identify them in the data. I have been setting up a big filter: "if any of these are true: userID=..." and then putting all 50+ IDs into the filter, each on a separate line, then editing the filtered cases.
Setting up that filter is a pain, is there a way to do it as a batch? I think I could download the dataset, add a variable that identifies bad cases and then re-upload, is that true? Are there any other faster / more efficient ways to approach this?
Question
Most efficient way to remove bad respondents?
Create a new field in the data and analysis tab, use the filter function to filter out the relevant ones and then add a value to them.
https://community.qualtrics.com/XMcommunity/discussion/comment/39490#Comment_39490Hmm, I see this is showing as an "accepted answer," but in fact it does not answer my question. The problem is the filter requires one statement / one line per respondent, because I'm filtering by unique user IDs. This is heavily manual -- I need to copy/paste one ID per line. Is there any way to filter all my bad IDs in a batch?
Hmm, thank you, but I guess what I still don't understand is: if I have identified several dozen cases out of 1000 or so that gave bad open ends, what's the best way to filter down to just those bad cases? I know how to tag them all once I have them selected, but I don't know a good way to select them other than by creating a big filter with one line for each respondent ID. How can I select just those fraudulent respondents so I can apply tags?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.