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

Direct query - Direct Discovery - Error

Hi All,

I am using direct query in one of my Qlik applications, but i am getting the below error

ErrorSource: OraOLEDB, ErrorMsg: ORA-01795: maximum number of expressions in a list is 1000

When i am selecting the filters to populate the table through Direct discovery.

Any help would be highly appreciated.

Thanks..

2 Replies
Not applicable

Re: Direct query - Direct Discovery - Error

Please post the query

Vegar
Valued Contributor II

Re: Direct query - Direct Discovery - Error

You are sending to many values into your automatic generated sql where statement. Oracle have a limit on 1000 values in is where statement and you are sending.

WHERE

Field IN value1, value2, ..., value1000, value 1001 etc.

Try limit the number of values in your D discovery. Maybe you could use a dimension and not a transaction key?

Please ekskuse my Norglish and Swenglish typos.