topic Help with SQL query (starts with "WITH") in QlikView

Help with SQL query (starts with "WITH")

Thu, 09 Sep 2010 23:10:39 GMT

Hi,

I'm pretty new to QV, but got a few simple queries to work and reports created.

I'm now trying to copy and paste a more complex SQL query into QV, but seems to have issues in even recognizing the keywords.

The query is something like this.

WITH xyz AS (Select ...... ) Select .... from xyz

I added the SQL tag in front of 'with' in the QV editor.

Only the 'with' keyword turned blue .... other keywords like Select, from, ... do not seem to get recoganised and as expected, gives an error

SQL Error:[Oracle][ODBC][Ora]ORA-00936: missing expression SQL Scriptline: SQL State:S1000

Any suggestions?

Thanks,

Vijay

llauses243 — Fri, 10 Sep 2010 10:23:14 GMT

Hi,

See attached ... my offer is to decompose using select and load

good luck, Luis

Sat, 11 Sep 2010 02:18:09 GMT

Thanks Luis. I'll try it.