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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Direct Discovery - Issue with export to Excel.

Hi Experts,

I have a QV document which has a simple direct query embedded with no measures.

DIRECT QUERY DIMENSION AS_OF DETAIL COL_1, COL_2, COL_3, COL_4, COL_5

FROM DB.SCH.TABLE_NAME

WHERE AS_OF > '1/1/2016'

The document has a list box with dimension AS_OF and a table box which has dimension and all detail columns added. Everything is working well wherein when i select a different as_of in list box, table gets refreshed with data from database server.

Only problem is export to excel doesn't works. As soon as i click export to excel, table has big cross on it. Someone mentioned here that excel export wont work if you have measure in table box but i have no measure. QV documentation has no mention on this limitation.

Does anyone has any insight? Did i miss something?

Thanks all in advance!

0 Replies