topic Re: convert formula in excel to Q in QlikView https://community.qlik.com/t5/QlikView/convert-formula-in-excel-to-Q/m-p/738914#M264083 <HTML><HEAD></HEAD><BODY><P>Maybe this:</P><P>=IF(RANGEMAX(ALT(RANGEMAX(1-FABS(O61-N61)/O61,0),1),0)&gt;1,0,RANGEMAX(ALT(RANGEMAX(1-FABS(O61-N61)/O61,0),1),0))</P></BODY></HTML> Thu, 16 Oct 2014 14:35:42 GMT Gysbert_Wassenaar 2014-10-16T14:35:42Z convert formula in excel to Q https://community.qlik.com/t5/QlikView/convert-formula-in-excel-to-Q/m-p/738913#M264082 <HTML><HEAD></HEAD><BODY><P>I am new to Q and i am trying to convert formula in excel to Q. Appreciate your help </P><P></P><P>=IF(+MAX(+IFERROR(MAX(1-ABS(O61-N61)/O61,0),1),0)&gt;1,0,+MAX(+IFERROR(MAX(1-ABS(O61-N61)/O61,0),1),0))</P></BODY></HTML> Thu, 16 Oct 2014 14:24:52 GMT https://community.qlik.com/t5/QlikView/convert-formula-in-excel-to-Q/m-p/738913#M264082 2014-10-16T14:24:52Z Re: convert formula in excel to Q https://community.qlik.com/t5/QlikView/convert-formula-in-excel-to-Q/m-p/738914#M264083 <HTML><HEAD></HEAD><BODY><P>Maybe this:</P><P>=IF(RANGEMAX(ALT(RANGEMAX(1-FABS(O61-N61)/O61,0),1),0)&gt;1,0,RANGEMAX(ALT(RANGEMAX(1-FABS(O61-N61)/O61,0),1),0))</P></BODY></HTML> Thu, 16 Oct 2014 14:35:42 GMT https://community.qlik.com/t5/QlikView/convert-formula-in-excel-to-Q/m-p/738914#M264083 Gysbert_Wassenaar 2014-10-16T14:35:42Z