5 Replies Latest reply: Aug 11, 2017 3:10 AM by Onno van Knotsenburg RSS

    How to write a single IF statement

    Ian Gunning

      Hello

      How can I write the below sql case statement in Qlik sense

      CASE WHEN [MY ORG CODE] = '11NA' THEN 'MY ORG NAME' ELSE [MY ORG CODE] END

       

      I have tried using match but I am not getting the correct results

      =match([MY ORG CODE], '11NA', 'MY ORG NAME', [MY ORG CODE])

       

      Thanks any help appreciated

      Ian