Is IF statement supports.

[#1]

Hi,

My data is from SYBASE- Database. So is IF statement will support at script

Thank you.

[anbu1984]

Check the reply in this thread

Case statement Replacement

[#3 · Accepted solution]

The IF statement is part of QlikView Engine. So using the Preceding Loading feature is really transparent what Database Server you use.

ie:

QlikViewTable:

LOAD code, IF (flag="Y","YES","NO") as FLAGGED;

and then

SQL SELECT code,flag from SybaseTable;

Note above that the preceding loading means the LOAD is just before the SQL statement and terminated with semicolon ; just before the SQL keyword.