topic Re: translate to qlikview script in QlikView https://community.qlik.com/t5/QlikView/translate-to-qlikview-script/m-p/1434481#M431062 <HTML><HEAD></HEAD><BODY><P>Hi Mfikri,</P><P></P><P>=IF(G169=0 or J169=0 or Len(Y169)=0 or Len(Z169)=0, '',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(Z169&gt;=5 and Y169&gt;=5, 'Kuadran I',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(Z169&lt;=5 and Y169&gt;=5, 'Kuadran II',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(Z169&lt;5 and Y169&lt;5, 'Kuadran III', 'Kuadran IV'</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P></BODY></HTML> Wed, 06 Dec 2017 04:28:47 GMT tamilarasu 2017-12-06T04:28:47Z translate to qlikview script https://community.qlik.com/t5/QlikView/translate-to-qlikview-script/m-p/1434480#M431061 <HTML><HEAD></HEAD><BODY><P>Dear all master qlikview </P><P>script from excel =IF(OR(G169=0,J169=0,Y169="",Z169=""),"",IF(AND(Z169&gt;=5,Y169&gt;=5),"Kuadran I",IF(AND(Z169&lt;=5,Y169&gt;=5),"Kuadran II",IF(AND(Z169&lt;5,Y169&lt;5),"Kuadran III","Kuadran IV"))))</P><P></P><P>please translate to qlikview script</P></BODY></HTML> Wed, 06 Dec 2017 04:17:40 GMT https://community.qlik.com/t5/QlikView/translate-to-qlikview-script/m-p/1434480#M431061 mfikrirahmat 2017-12-06T04:17:40Z Re: translate to qlikview script https://community.qlik.com/t5/QlikView/translate-to-qlikview-script/m-p/1434481#M431062 <HTML><HEAD></HEAD><BODY><P>Hi Mfikri,</P><P></P><P>=IF(G169=0 or J169=0 or Len(Y169)=0 or Len(Z169)=0, '',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(Z169&gt;=5 and Y169&gt;=5, 'Kuadran I',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(Z169&lt;=5 and Y169&gt;=5, 'Kuadran II',</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(Z169&lt;5 and Y169&lt;5, 'Kuadran III', 'Kuadran IV'</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</P></BODY></HTML> Wed, 06 Dec 2017 04:28:47 GMT https://community.qlik.com/t5/QlikView/translate-to-qlikview-script/m-p/1434481#M431062 tamilarasu 2017-12-06T04:28:47Z