Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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'