Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Oracle query performance

I have an Oracle query that gives me a good and quick result in an Oracle query tool.

It gives me 0 records in return when running in Qlikview when the Oracle query has a where clause: Where datum = '3-12-2012'

It runs indefinite when the where clause is Where datum > '3-12-2012'

any ideas ?

Tags (1)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Oracle query performance

There are two issues here:
1. QV11 script doesn't return an error if the SQL is incorrect, just loads 0 rows and continues.  Probbaly this is your situation.
2. Using date condition in Oracle within QV script - see this http://community.qlik.com/docs/DOC-1321

Regards,
Michael

1 Reply
mov
Esteemed Contributor III

Re: Oracle query performance

There are two issues here:
1. QV11 script doesn't return an error if the SQL is incorrect, just loads 0 rows and continues.  Probbaly this is your situation.
2. Using date condition in Oracle within QV script - see this http://community.qlik.com/docs/DOC-1321

Regards,
Michael