Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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)
IAMDV
Luminary Alumni
Luminary Alumni

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
Author

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