Unexplained syntax error

Tue, 13 Jan 2015 16:25:47 GMT

;

syntax error missing/misplaced from load

Not sure why I get this. I do not get any red brackets in the code. Is there a way to troubleshoot unexplained syntax errors

load

/*To format the IDI flag*/
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',

    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'),'N')) as IDI

*
;

load

if ([IDI]='N',trial4_due_dt= .,([4th Trial Made])= .),

*
;

Re: Unexplained syntax error

Anonymous — Tue, 13 Jan 2015 16:33:21 GMT

Do you need a comma after as IDI

Re: Unexplained syntax error

jpapador — Tue, 13 Jan 2015 17:12:35 GMT

Like Bill mentioned you need a comma after IDI but before the *. Also in your second load statement, you may need single quotes around the period in your if statement.

Re: Unexplained syntax error

Tue, 13 Jan 2015 17:14:46 GMT

Thanks Bill

Re: Unexplained syntax error

Tue, 13 Jan 2015 17:14:56 GMT

thanks

topic Re: Unexplained syntax error in QlikView

Unexplained syntax error

Re: Unexplained syntax error

Re: Unexplained syntax error

Re: Unexplained syntax error

Re: Unexplained syntax error