Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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