topic Re: Please convert the Oracle syntax into qlik view expression in QlikView https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794980#M667459 <HTML><HEAD></HEAD><BODY><P>rangemax(0,OS)</P></BODY></HTML> Sun, 09 Nov 2014 19:01:51 GMT Gysbert_Wassenaar 2014-11-09T19:01:51Z Please convert the Oracle syntax into qlik view expression https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794979#M667458 <HTML><HEAD></HEAD><BODY><P>nvl (decode(sign(OS),-1,0,OS),0)</P></BODY></HTML> Sun, 09 Nov 2014 18:09:32 GMT https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794979#M667458 2014-11-09T18:09:32Z Re: Please convert the Oracle syntax into qlik view expression https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794980#M667459 <HTML><HEAD></HEAD><BODY><P>rangemax(0,OS)</P></BODY></HTML> Sun, 09 Nov 2014 19:01:51 GMT https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794980#M667459 Gysbert_Wassenaar 2014-11-09T19:01:51Z Re: Please convert the Oracle syntax into qlik view expression https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794981#M667460 <HTML><HEAD></HEAD><BODY><P>NVL-is for checking null values</P><P>IF decode(sign(OS))=-1 then 0 else OS</P><P>IF NULL = 0</P><P></P><P>Please convert into Qlik view expression</P></BODY></HTML> Mon, 10 Nov 2014 05:12:14 GMT https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794981#M667460 2014-11-10T05:12:14Z Re: Please convert the Oracle syntax into qlik view expression https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794982#M667461 <HTML><HEAD></HEAD><BODY><P><STRONG>if(If(OS&lt;0,0,OS)=null(),0,If(OS&lt;0,0,OS))</STRONG></P></BODY></HTML> Mon, 10 Nov 2014 05:20:29 GMT https://community.qlik.com/t5/QlikView/Please-convert-the-Oracle-syntax-into-qlik-view-expression/m-p/794982#M667461 sujeetsingh 2014-11-10T05:20:29Z