topic Re: Connect to Qlikview from Excel in QlikView

Connect to Qlikview from Excel

mayuranp — Tue, 04 Sep 2018 12:23:36 GMT

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

Re: Connect to Qlikview from Excel

Michiel_QV_Fan — Tue, 04 Sep 2018 12:26:35 GMT

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

Re: Connect to Qlikview from Excel

mayuranp — Tue, 04 Sep 2018 12:31:04 GMT

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

It is about viewing Qlikview data in an excel document.

Re: Connect to Qlikview from Excel

Sergey_Shuklin — Tue, 04 Sep 2018 12:32:23 GMT

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?

Re: Connect to Qlikview from Excel

Michiel_QV_Fan — Tue, 04 Sep 2018 12:33:35 GMT

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

Would that be sufficient?

Re: Connect to Qlikview from Excel

marcus_sommer — Tue, 04 Sep 2018 13:36:37 GMT

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

Re: Connect to Qlikview from Excel

Peter_Cammaert — Tue, 04 Sep 2018 14:25:47 GMT

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

Re: Connect to Qlikview from Excel

marcus_sommer — Tue, 04 Sep 2018 14:53:18 GMT

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

Re: Connect to Qlikview from Excel

Peter_Cammaert — Tue, 04 Sep 2018 15:41:33 GMT

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

Re: Connect to Qlikview from Excel

zarmoton — Wed, 29 Jan 2020 15:29:18 GMT

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.

Re: Connect to Qlikview from Excel

congtv — Tue, 07 Sep 2021 15:50:10 GMT

Too bad that Qlik makes it easy to import excel data to Qlik, but not vice versa. Our brilliant IT guys somehow decided to use Qlik as "central data warehouse" while most people don't have Qlik licenses and everyone uses Excel for reporting.

Re: Connect to Qlikview from Excel

mayuranp — Fri, 24 Sep 2021 14:53:59 GMT

I came across Analytics Gate, Qlik Sense plug-in. Has anyone used this? This might be the solution to our problem.

Re: Connect to Qlikview from Excel

qliknubi — Tue, 14 Dec 2021 11:45:22 GMT

Hi Mayuranp, Were you able to test analyticsgate?