1 Reply Latest reply: Mar 18, 2016 3:32 AM by Gysbert Wassenaar RSS

    ¿Translate Excel function to Qlik Sense?

    Sebastián Garcíá

      Hi Dears,

       

      I need please translate the following function(Excel) to QlikSense:

       

      =IF(AND(IF(AL2-AJ2>=0,003473;IF(AL2-AJ2<0,25;"1";0);0)="1";IF(AN2-AL2>=0,0069445;IF(AN2-AL2<=0,4167;"1";0);0)="1");"OK";"NO OK")

       

      The last function works in Excel.

       

      Thanks all!