How to create output that equals answer of Q1 but if Q1 = empty, it's answer of Q2 | XM Community
Skip to main content
Dear all,



I have different questions but not all are visible to the respondent.

I would need to create an output (for example an embedded data in survey flow) that would be the following:



If scale question 1 has an answer, the output should include this answer, if it's empty than the output should include the answer of scale question 2. If both are empty the output should equal N/A

Currently we use this formula in Excel to receive the desired output.



=IF(NOT(ISBLANK(A1));A1;IF(NOT(ISBLANK(B1));B1;"n/a"))



with column A having the answers of Q1 and column B having the answers of Q2



The goal would be to have a seperate column in the reporting section of Qualtrics that would have this logic (so we don't have to manually do it in Excel afterwards).



Thanks in advance!!!
Set an embedded data field in the survey flow after questions 1 and 2, for instance, called Output, with no value

set up three branches:

1. If Q1 is empty (neither of options selected) "Output"=Q2 (Selected answer, or recode, whatever you are after)

2. If Q2 is empty (neither of options selected) "Output"=Q1

3. If Q1 AND Q2 is empty (neither of options selected) "Output"=N/A

Leave a Reply


Terms & Conditions