topic Error in script in QlikView https://community.qlik.com/t5/QlikView/Error-in-script/m-p/47801#M7953 <HTML><HEAD></HEAD><BODY><P>Hello Friends</P><P></P><P>I have an an error in my below script. Kindly advise me to correct it </P><P></P><P>if(MATCH(POL_TYPE,'N','R','F')AND IF(DATE(DATE#(T_DATE,'YYYY-MM'))='2018-01',applymap('PP1',POL_PTO,NULL()))as NO_OF_RISKS</P></BODY></HTML> Mon, 05 Feb 2018 04:03:37 GMT upaliwije 2018-02-05T04:03:37Z Error in script https://community.qlik.com/t5/QlikView/Error-in-script/m-p/47801#M7953 <HTML><HEAD></HEAD><BODY><P>Hello Friends</P><P></P><P>I have an an error in my below script. Kindly advise me to correct it </P><P></P><P>if(MATCH(POL_TYPE,'N','R','F')AND IF(DATE(DATE#(T_DATE,'YYYY-MM'))='2018-01',applymap('PP1',POL_PTO,NULL()))as NO_OF_RISKS</P></BODY></HTML> Mon, 05 Feb 2018 04:03:37 GMT https://community.qlik.com/t5/QlikView/Error-in-script/m-p/47801#M7953 upaliwije 2018-02-05T04:03:37Z Re: Error in script https://community.qlik.com/t5/QlikView/Error-in-script/m-p/47802#M7954 <HTML><HEAD></HEAD><BODY><P>Hi Upali,</P><P></P><P>Try this,</P><P></P><P>if(MATCH(POL_TYPE,'N','R','F') AND DATE(DATE#(T_DATE,'YYYY-MM'))= '2018-01',applymap('PP1',POL_PTO,NULL())) as NO_OF_RISKS</P></BODY></HTML> Mon, 05 Feb 2018 04:09:52 GMT https://community.qlik.com/t5/QlikView/Error-in-script/m-p/47802#M7954 tamilarasu 2018-02-05T04:09:52Z