topic Re: If match Error in logic troubleshooting in QlikView

If match Error in logic troubleshooting

Fri, 30 Jan 2015 19:16:23 GMT

if ( (match([D Investor],'FNMA','FHLMC','FHA') ,
    if (match([Product Type],'MOD24','APOLLO','ALT2011','ALTMOD','CAPMOD','HUDMOD','HUDPCLM'),'N'),


if( (match([D Investor],'FNMA') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
      (match([D Investor],'SunTrust') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
        match([D Investor],'VA','PRIVATE / REG AB') or
         match([D Investor],'FHA') and Match([Product Type],'FHAHAMP')))), 'Y', as [IDI] ,

I get an error where the red comma is located right after FHA. My objective here is show an ‘N’ or a ‘Y’ based on the above referenced logic. The red comma is my only error. Am I not enclosing a bracket in the correct place

Re: If match Error in logic troubleshooting

sunny_talwar — Fri, 30 Jan 2015 19:24:26 GMT

Is there a extra parenthesis after the very first if?

if ( (match([D Investor],'FNMA','FHLMC','FHA') ,
    if (match([Product Type],'MOD24','APOLLO','ALT2011','ALTMOD','CAPMOD','HUDMOD','HUDPCLM'),'N'),


if( (match([D Investor],'FNMA') and match([Product Type],'HMP') and [Last FTPMBM Date] >=[Setup Date]) or
      (match([D Investor],'SunTrust') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
        match([D Investor],'VA','PRIVATE / REG AB') or
        match([D Investor],'FHA') and Match([Product Type],'FHAHAMP')))), 'Y', as [IDI]

I may be totally wrong, but to me it seems that only one is required.

Best,

Re: If match Error in logic troubleshooting

Fri, 30 Jan 2015 19:37:26 GMT

That worked. Let me ask is there a best practices way to analyze when to and not to insert the brackets. That is the area that is the most challenging

Re: If match Error in logic troubleshooting

sunny_talwar — Fri, 30 Jan 2015 19:42:36 GMT

Its not an exact science. Every time you open a parenthesis you need to close it, but in case you put too many or too less parenthesis, QlikView will give you an error

I wish there was an easy way out.

Best,