Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
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

Partner
Partner

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?

Plees ekskuse my Swenglish and or Norweglish spelling misstakes