Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to show Qlikview-Data in Excel (2010).
For this I installed Qlikview 8.5 because of the ODBC driver.
Now I wanted to extract some data out of my Qlikview-App. So I made a new ODBC-Data Source in my Win7. In Excel I tried to open that connection (ODBC DSN) via the Excel menue "Connections". I found that Connection in the following menue but I got the exception :
No Tablelists could be found on that data source (or sth. like that because I use the german version...
Can anyone explain me how I can extract data like that?
Thank you in advance!
Regards,
Michael
mich,
I think you are asking how to query from excel. Here is an example from what I use.
LOAD EMPLOYEENUMBER,
MONTH,
MARGINQUOTA,
REVENUEQUOTA
FROM
C:\QlikViewReports\Sourcedocuments\DataFiles\Quota.xlsx
(ooxml, embedded labels, table is Sheet1);
Note the syntax where the table is Sheet1. Sheet1 is the name of the excel worksheet tab.
Nothing was required in terms of ODBC as I was simply querying from an excel file in a directory on the same server.
Kal
Hi Kal,
this is not the way I want to do it. I want to do it totally the other way round. I want to load a table from Qlikview in Excel to work with it as a pivot table in Excel
What you explained is the normal Excel-load in Qlikview
Greets