Discussion Board for collaboration on QlikView Scripting.
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.
Please post the query
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.
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?