topic Direct Discovery - Issue with export to Excel. in QlikView https://community.qlik.com/t5/QlikView/Direct-Discovery-Issue-with-export-to-Excel/m-p/1276488#M438094 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I have a QV document which has a simple direct query embedded with no measures.</P><P></P><P>DIRECT QUERY DIMENSION AS_OF DETAIL COL_1, COL_2, COL_3, COL_4, COL_5</P><P>FROM DB.SCH.TABLE_NAME</P><P>WHERE AS_OF &gt; '1/1/2016'</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Does anyone has any insight? Did i miss something?</P><P></P><P>Thanks all in advance!</P></BODY></HTML> Sun, 04 Dec 2016 14:52:47 GMT 2016-12-04T14:52:47Z Direct Discovery - Issue with export to Excel. https://community.qlik.com/t5/QlikView/Direct-Discovery-Issue-with-export-to-Excel/m-p/1276488#M438094 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I have a QV document which has a simple direct query embedded with no measures.</P><P></P><P>DIRECT QUERY DIMENSION AS_OF DETAIL COL_1, COL_2, COL_3, COL_4, COL_5</P><P>FROM DB.SCH.TABLE_NAME</P><P>WHERE AS_OF &gt; '1/1/2016'</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Does anyone has any insight? Did i miss something?</P><P></P><P>Thanks all in advance!</P></BODY></HTML> Sun, 04 Dec 2016 14:52:47 GMT https://community.qlik.com/t5/QlikView/Direct-Discovery-Issue-with-export-to-Excel/m-p/1276488#M438094 2016-12-04T14:52:47Z