Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Error in script

Hello Friends

I have an an error in my below script. Kindly advise me to correct it

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

1 Solution

Accepted Solutions
Highlighted

Hi Upali,

Try this,

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

View solution in original post

1 Reply
Highlighted

Hi Upali,

Try this,

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

View solution in original post