switch statement in qlikview expression

[#1]

Dear experts,

I am having a trouble in converting SQL IF statement to qlikview switch case expression.

These are statements I am trying to convert:

select columnA, ColumnB From TableA WHERE ColumnA BETWEEN 501 AND 515 

select column1, Column2 From Table1 WHERE Column1 in ('John','Pieter')

[Anonymous]

Try this:

SQL SELECT cloumn A,ColumnB

From Table A Where (ColumnA>='501' & ColumnA <='515');

[anbu1984]

ColumnA >= 501 AND ColumnA <= 515

Match(Column1,'John','Pieter') > 0