Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Please post the query

Vegar
MVP
MVP

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?