Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Is IF statement supports.

Hi,

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

Thank you.

1 Solution

Accepted Solutions
Not applicable

Re: Is IF statement supports.

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.

2 Replies
anbu1984
Honored Contributor III

Re: Is IF statement supports.

Check the reply in this thread

Case statement Replacement

Not applicable

Re: Is IF statement supports.

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.

Community Browser