Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. 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