QlikSense throws error in query that works just fine in SQLDev

[Sofichina]

Hi!

I put together a query in SQL Developer that works just fine but when I paste it in QlikSense (like I always do) it throws the error: "ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00936: missing expression"

I've already checked commas, select and from statements.

Like I said, the exact same query runs just fine in SQL Developer. Its the first time something like this happens and I couldn't find anyone that has the same problem.

Thank you in advance!

[danielrozental]

Can you paste your query?

[Sofichina]

The query is:

[danielrozental]

You're query seems ok.

Have you tried starting with a more simple version and build it up to see when you start getting the error?

For example, does something like this work?

SELECT
SUM (r.cambio ) AS STOCK

FROM sigsa.cambiohistorico r

[Sofichina · Accepted solution]

Thank you for your answer! I did as you said and it turns out the "date(today())" was crushing the query in Qlik. I solved it by defining a variable vDate = date(today()) in Main and calling it out as "$vDate"