topic Re: Error in Direct Query !! in QlikView

Error in Direct Query !!

nikhilgarg — Wed, 19 Nov 2014 05:41:18 GMT

HEy,

I tried to implement directquery example by small example but it is giving error that ODBC connection failed when i am fetching data from excel sheet by direct query.

Data3:

DIRECT QUERY

dimension

Month

measure

Value

FROM Example1.xls;

Please tell what to do.

Thanks

Re: Error in Direct Query !!

tresB — Wed, 19 Nov 2014 05:44:23 GMT

Direct query requires ODBC connection. Learn it from pdf you would find here: What is Direct Query? What are the advantages?

Re: Error in Direct Query !!

jagan — Wed, 19 Nov 2014 06:05:03 GMT

Hi Nikhil,

Direct Discovery works on ODBC, It will fetch data from databases only. So, store this excel file data into database table and create ODBC to the database and then try.

Regards,

Jagan.

Re: Error in Direct Query !!

nikhilgarg — Wed, 19 Nov 2014 06:16:50 GMT

Hey,

Thanks for information.