topic Re: If else syntax error in script in QlikView

If else syntax error in script

rdsuperlike — Sat, 21 Mar 2015 00:21:23 GMT

Wat is the issue in this code? I have kept it in the script

I am getting error related to If and else. Anything wrong with the syntax?

Set flag = 'N';

If $(flag) = 'N'

Set $(vPO) = $(vPO_C) ;

Set $(vPSL) = $(vPSL_C) ;

Set $(vSHIP) = $(vSHIP_C);

ELSE

Set $(vPO) = $(vPO_H) ;

Set $(vPSL) = $(vPSL_H);

Set $(vSHIP) = $(vSHIP_H);

ENDIF;

Any input would be appreciated

robert_mika — Sat, 21 Mar 2015 00:49:00 GMT

Try add Then

If $(flag) = 'N' then

Set $(vPO) = $(vPO_C) ;

Set $(vPSL) = $(vP......

trdandamudi — Sat, 21 Mar 2015 01:52:54 GMT

You are missing 'Then' in the syntax.... Below is the syntax of If.... Then.... Else:

if condition then

[ statements ]

{ elseif condition then

[ statements ] }

[ else

[ statements ] ]

end if