topic SQL in QlikView script in QlikView

SQL in QlikView script

Wed, 08 Aug 2012 10:47:21 GMT

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

Re: SQL in QlikView script

Wed, 08 Aug 2012 11:04:18 GMT

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)

Re: SQL in QlikView script

IAMDV — Thu, 09 Aug 2012 12:34:36 GMT

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,

www.QlikShare.com

Re: SQL in QlikView script

Thu, 09 Aug 2012 12:37:03 GMT

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