2 Replies Latest reply: Nov 17, 2016 3:03 PM by Sunny Talwar RSS

    Dual If (and) statements

    Marina Amorim

      I am having a hard time to elaborate this formula on QlikView. I am new with the system. Could someone help me please.

       

      =If(And("Goals Quantification"=1,Actual-Goal<0,"Red","Green",If(And("Goals
      Quantification"=2,Goal-Actual>0,"Green","Red")))

       

       

      Thanks.