topic Re: 2 or 3 arguments error in multiple if statement in QlikView

2 or 3 arguments error in multiple if statement

Wed, 07 Jan 2015 16:26:04 GMT

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],

Re: 2 or 3 arguments error in multiple if statement

Wed, 07 Jan 2015 16:27:34 GMT

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

Re: 2 or 3 arguments error in multiple if statement

Wed, 07 Jan 2015 16:28:54 GMT

You need to close ) after the match

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

replaced by

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

Re: 2 or 3 arguments error in multiple if statement

rubenmarin — Wed, 07 Jan 2015 16:29:27 GMT

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]

Re: 2 or 3 arguments error in multiple if statement

Wed, 07 Jan 2015 16:30:01 GMT

Ok I will try it

Re: 2 or 3 arguments error in multiple if statement

jpapador — Wed, 07 Jan 2015 16:31:24 GMT

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