I've spent a while coming up with a query for an Oracle dB, but QLikview doesn't seem to accept it at all. I'm quite sure it's not T-SQL and am fairly sure I conformed to ANSI but still QV isn't having it. Attached is a test app with the load script, any suggestions would be helpful!
as your query isn't a trivial one, use a different tool (sqlplus, sql developer, toad, etc....) to test the query on an oracle database; when the syntax of the query is ok, add the query to QlkiView script (usually a correct query run without any problem in QlikView load script but debugging and testing the query is easier in an external and ad hoc tool)
