Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
mayuranp
Creator
Creator

Connect to Qlikview from Excel

Is there a way to connect to Qlikview or Qliksense from excel file via a connector or third party plugin?

To clarify, this is not loading data from excel into QVW. This is about viewing Qlikview data in excel files.

Thanks

12 Replies
Michiel_QV_Fan
Specialist
Specialist

Yes, you can use ODBC. Search the forum, this question has been answered more than once.

For instance:

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

mayuranp
Creator
Creator
Author

The question is not about loading the data from excel onto Qlikview.

It is about viewing Qlikview data in an excel document.

Sergey_Shuklin
Specialist
Specialist

Hello!

What kind of connection it should be? Obvious, that you can use the same sources of data (except QVD)

But what can be else? Linking formulas and tables from QV-reports to Excel?

Michiel_QV_Fan
Specialist
Specialist

Store your data in a txt file. You can open that in excel.

Would that be sufficient?

marcus_sommer

You will need any kind of data-output (xls, csv, txt, db, ...) to view QlikView data within Excel. But by using Qlik Sense you could "merge" both tools, see: https://senseexcel.com/.

- Marcus

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Indeed, you can embed QlikView objects in MS-Office documents (most spectacularly used in PowerPoint presentations), as long as you have access to QlikView documents, i.e. you should have a license and either QV Desktop or Plugin for internet explorer installed.

See

Embedding QlikView Objects into MSOffice Documents

marcus_sommer

Did it ever work for you? I tried it some years ago and now in Office 365 but it never worked for me. Could there be any here not mentioned requirements on the included office-dll's or with any ActiveX settings (AFAIK this feature is based on ActiveX) or anything else?

- Marcus

Peter_Cammaert
Partner - Champion III
Partner - Champion III

I got it to work whenever needed, mostly for demo purposes because customers never used it that much. I didn't test with Office365 or QV12 yet, but if I can find the time I'll try again.

Peter

zarmoton
Creator
Creator

I used a fantastic tools QVEXCEL. But the company who provided this tools as closed.

I have a free licence , but this product work only up to version 11.2, and not with server 12.x

It is really too bad.

 

I'm dreaming to find a similar tool , easy to access to any object in a QVW. and really easy to build formula of Set analysis in excel to query QV.