topic switch statement in qlikview expression in QlikView

switch statement in qlikview expression

Tue, 13 May 2014 11:38:40 GMT

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 — Tue, 13 May 2014 11:46:17 GMT

Try this:

SQL SELECT cloumn A,ColumnB

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

anbu1984 — Tue, 13 May 2014 11:51:07 GMT

ColumnA >= 501 AND ColumnA <= 515

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