topic Switch Statement in QlikView

Switch Statement

Tue, 24 Nov 2009 23:35:13 GMT

Hi,

Could someone help me with the correct syntax for Switch statement?

I have read through the forum threads on Switch statement but there doesn't seem to be any error free syntax.

Thanks,

Switch Statement

Tue, 24 Nov 2009 23:40:34 GMT

Well the normal syntax is

switch variable

case 1

case 2

end switch

What do you need else regarding switch feature ?

Rgds,

Sébastien

Switch Statement

Tue, 24 Nov 2009 23:43:44 GMT

Hi Sebastien,

Thanks for that.

I have applied the syntax as you have given. But the above syntax doesnt work. It returns a 'Line Error' and I know that I have not made any other mistakes in the query.

Switch Statement

Tue, 24 Nov 2009 23:46:17 GMT

Coud you paste the copy of the script ?

Switch Statement

Miguel_Angel_Baeyens — Tue, 24 Nov 2009 23:54:23 GMT

Hi,

Do you end your case statements with semicolon?

switch expr
 case first_possible_value_of_expr
 do something;
 case second_possible_value_of_expr
 do something else;
 default
 do otherwise;
end switch

Is your "do something" statements length more than one line?

Switch Statement

Wed, 25 Nov 2009 00:23:28 GMT

Here is a simple example which works:

let

expr =2

;

switch

expr

case

TOTO:

LOAD

* INLINE

[

;

default

TOTO:

LOAD

* INLINE

[

;

end

switch