3 Replies Latest reply: Aug 9, 2012 8:37 AM by Felim Shanaghy RSS

    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