topic switch control statement in QlikView

switch control statement

qlikviewwizard — Fri, 11 Sep 2015 11:18:37 GMT

Hi All,

I am not clear about switch control statement.

Please give an example to Switch.

Thanks in advance.

Re: switch control statement

Ralf-Narfeldt — Fri, 11 Sep 2015 11:28:59 GMT

This is from the QlikView help.

If I evaluates to 1, the first load statement is executed, if I evaluates to 2 the second load statement is executed and in any other case the third load statement is executed.

Examples:

switch I

case 1

load '$(I): CASE 1' as case autogenerate 1;

case 2

load '$(I): CASE 2' as case autogenerate 1;

default

load '$(I): DEFAULT' as case autogenerate 1;

end switch

Re: switch control statement

Anonymous — Fri, 11 Sep 2015 13:09:25 GMT

Hi,

Switch control statement(conditional statement) used to control logical flow of script execution. Executes one of many choices,based on the value of an expression. If no match is found for the value, the DEFAULT statements are executed.

SWITCH I

CASE 1

[Executed when ‘I’ is 1]

CASE 2

[Executed when ‘I’ is 2]

CASE 3

[Executed when ‘I’ is 3]

DEFAULT

[Executed when ‘I’ is not 1 or 2 or 3]

END SWITCH