Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

¿Translate Excel function to Qlik Sense?

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!

1 Reply
Gysbert_Wassenaar

if(AL2-AJ2>=0.00347 and AL2-AJ2<0.25 and AN2-AL2>=0.0069445 and AN2-AL2<=0.4167, 'OK', 'NO OK')


talk is cheap, supply exceeds demand