1 Reply Latest reply: May 30, 2018 5:39 AM by Anton van Keep RSS

    Need help on IF Logic

    Mahitha M

      Hi Experts,

       

      Can any one please help me to replicate the below logic into qlik

       

      =If(OR(ISBLANK(Startdate ), ISBLANK(Enddate)),"",

           IF(AND(Type="New",Status="Completed"),NETWRORKDAYS(Startdate,Enddate), "")

        )


      Thanks in advance.