Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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!

Tags (1)