5 Replies Latest reply: Jan 8, 2016 5:54 AM by Daniel Morley RSS

    Creating a Measure with Multiple Conditions



      I'm new to SQL and QlikSense and I am looking to create a new measure/field based on two conditions but I can't seem to get it to work. I'm using it in a sporting environment and want to make a new measure called 'Successful Forward Pass'. I have two measures called 'Pass Outcome' and 'Pass Direction' already and I've tried IF statements like:


      if(Count(DIRECTION)='Forward' and Count([PASS OUTCOME])= 'Successful' as 'Successful Forward Pass'))


      Basically if the pass is forward and successful. Any help would be greatly appreciated.