2 Replies Latest reply: Apr 1, 2015 5:22 AM by Denis Windisch RSS

    Error in expression with count aggregation and if statement

      Hello hello,

       

      I want to calculate the portfolio but I get an error in my expression.

       

      COUNT (IF(MonthYear_Start<=Master_MonthYear AND
      Relevant_Sales=1 AND
      Contract_Status_Code -=0 AND
      Contract_Status_Code -= 10 AND
      (ISNULL(Month_End_Real)=-1 OR MonthYear_End_Real>=Master_MonthYear)), Contract_Key)

       

      Error: "Error in expression: ')' expected"

       

      I hope/think its a small mistake but I don't get it

       

      Is it right that -= is in Qlik Sense the new <> (NOT EQUAL)?