topic Using If in qlikview script in QlikView

Using If in qlikview script

eleni_theodorid — Wed, 25 Apr 2012 13:52:51 GMT

Could you please help me with this peace of script:

For i = 1 To $(LOOP_COUNTER)

if i = 1 Then SET SelectORJoin = 'Sql Select';

else SET SelectORJoin = 'Join (Table1) Select';

endif

Next i;

How could we write this in qlikview script?

Thanks a lot,

Helen

stevedark — Wed, 25 Apr 2012 14:04:01 GMT

Hi Helen,

Either with an inline join:

let SelectORJoin = if(i=1, 'SQL SELECT', 'JOIN (Table1) SELECT');

Or with an if structure like VBA:

if i = 1 then

let SelectORJoin = 'SQL SELECT';

else

let SelectORJoin = 'JOIN (Table1) SELECT';

end if

Note that semi colons are not required on the end of the construct lines, the one at the end of your next statement is also superfluous.

Hope that helps,

Steve

eleni_theodorid — Wed, 25 Apr 2012 14:23:58 GMT

The problem was the THEN, without it , it works fine:

For i = 1 To $(LOOP_COUNTER)

if i = 1 SET SelectORJoin = 'Sql Select';

else SET SelectORJoin = 'Join (Table1) Select';

endif;

Next i;

Thanks a lot!