4 Replies Latest reply: Nov 8, 2015 11:30 PM by vikas mahajan RSS

    Create an Expression

    Varinia Godoy

      Hello,

       

      I am new to QlikView and I am trying to do the following...

       

      I want to create a chart where the expression only calculates payments if the dimension called Pay Code is equal to 17 or 18.

       

      =IF(AND(PAYCODE='17',PAYCODE='18'),SUM(TRANSACTION_PAYMENT),NULL)


      What is the appropriate syntax for this expression?


      thanks!