Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

2 or 3 arguments error in multiple if statement

if (match([Investor],'FNMA'),
    
if (match([Product Type],'HMP' and FTPMBM >= [Loss Mit Status Change Date]),’Y’,
      
if (Match([Product Type],'MOD24','APOLLO','ALT2011','ALTMOD','CAPMOD'),'N'))) as [IDI],
  /*I    
if (match([Investor],'FHLMC'),'N')as [IDI],

if (match([investor],'VA','PRIVATE / REG AB'),'Y')as [IDI],


if (match([investor],'FHA'),
 
if (Match([Product Type],'HUDMOD','HUDPCLM'),'N',
   
if (Match([Product Type],'FHAHAMP'),'Y'))) as [IDI],

1 Solution

Accepted Solutions
Not applicable
Author

You need to close ) after the match

if (match([Product Type],'HMP' and

replaced by

if (match([Product Type],'HMP') and

View solution in original post

5 Replies
Not applicable
Author

Some of my statements did not save.  I am getting not enough argument errors here.  My question here is must I use a 'Y','N' for each scenario to avoid the not enough arguments error

Not applicable
Author

You need to close ) after the match

if (match([Product Type],'HMP' and

replaced by

if (match([Product Type],'HMP') and

rubenmarin

Hi, in 2nd 'if' you need to close the match function and remove the ')' before 'Y':


if (match([Investor],'FNMA'),
   
if (match([Product Type],'HMP') and FTPMBM >= [Loss Mit Status Change Date],’Y’,
     
if (Match([Product Type],'MOD24','APOLLO','ALT2011','ALTMOD','CAPMOD'),'N'))) as [IDI]

Not applicable
Author

Ok I will try it

jpapador
Partner - Specialist
Partner - Specialist

It doesnt look like you closed your match statement on the second line "if (match([Product Type],'HMP'