topic Function Switch in QlikView

Function Switch

Wed, 17 Jun 2009 03:26:16 GMT

I'm experiencing some problems with the switch function and I can not find the correct syntax.

Furthermore I would like to change a different variable "VAR" as follow:

=switch Country
case 'FR'
LET VAR = 'France';
case 'UK'
LET VAR = 'UnitedKinkgdoms';
default
LET VAR = 'Else';

end switch

Could you suggest one solution?

Thank you very much for your help, it drives me crazy!![:)].

Wed, 17 Jun 2009 14:02:25 GMT

Hi,

I can able see only one issue in your syntax.

Just remove Equal before the switch syntax and see.

Your syntax shoud be like this.


let Var = 'QW';

Switch Var

Case 'QW'

Let Var='I`m in QW';

Case 'AB'

Let Var='I`m in AB';

Default

Let Var='I`m in Default';

end switch

- Sridhar