Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

SQL in QlikView script

The more I work in QlikView the more I see that normal SQL is out of the question (a where statement for example ignores multiple "AND" statements)

I was wondering, since I can't find this in the documentation, if something like charindex() can work (I'm not on a machine with QV on and need to answer to my manager). We'd like to change a specific string field based on a "dash", ie something like, left(field_name,charindex('-',field_name)) as field_name

3 Replies
Not applicable

Re: SQL in QlikView script

Try like:
ODBC  CONNECT Statement
Table1:
Load
left(field_name,charindex('-',field_name)) as field_name,
Other_Field1,
Other_Field2;
SQL  SELECT
Field_Name,
Other_Field1,
Other_Field2
FROM (Statement)
dvqlikview
Honored Contributor II

Re: SQL in QlikView script

plrenviroserv wrote:

(a where statement for example ignores multiple "AND" statements)

Sorry, I'haven't fully understood but what do you mean in above statement? Please can you explain in-detail? You can use use "AND" statement witin Where clause.

Cheers,

DV

www.QlikShare.com

Not applicable

Re: SQL in QlikView script

    The SQL used by Qlikview is standard, you can use IN, AND etc etc

Community Browser