topic Re: Is IF statement supports. in QlikView

Is IF statement supports.

Mon, 29 Dec 2014 11:59:57 GMT

Hi,

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

Thank you.

anbu1984 — Mon, 29 Dec 2014 13:51:29 GMT

Check the reply in this thread

Mon, 29 Dec 2014 13:58:21 GMT

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.