Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
The SQL used by Qlikview is standard, you can use IN, AND etc etc