Direct query send to excel chart function functionalityArticle Number: 000042263 | Last Modified: 2018/11/21
Thus data is not well extracted when user try to use "Send to Excel" function and we see character "-" instead of values from dimension tables. The straight table however displays these values after certain amount of time.
Direct query has limitations with exporting to excel and this may also be related to a bug that has been logged in internally with Qlikview 11.20 SR10 release (QVII-803) and may not be fixed as this is relatively complex and the impact is low, overall.
We also see see that there are many limitations when using Direct query with joins, etc
Please go through the link below for more information on limitations with direct query when high-cardinality joins in combination with in-memory tables will produce large IN clauses that may exceed the SQL buffer limit of the data source.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.