1 Reply Latest reply on Oct 14, 2018 10:36 AM by Jim Dehner

    IF using string and multiple values

    Jaclynne Tan

      I am trying to sort my data for a questionnaire. In essence, I have some questions whereby if someone agreed, it is actually a negative response instead of a positive one.

      I was able to create a valid calculation in tableau but no fields were created.

       

      Can anybody advise on what might be causing this problem?

      -JTScreen Shot 2018-10-14 at 17.32.37.png

        • 1. Re: IF using string and multiple values
          Jim Dehner

          Good morning

          I would like to see the actual workbook in twbx format with the data

           

          the approach you are using requires an EXACT match (literal) to the text field -

          but you are generating nulls - i.e. you have no records that match the Qtype and response combination -

           

          I would test the formula in parts to see what has gone wrong - - e.g test the Qtype against the 2 stings  -

          if you get a return there - then test the response condition - then rebuild the combination

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.