How to integrate QlikView with Excel or any MS Office products

Most of my customers ask "Is it possible to integrate QlikView reports to Microsoft office Product Suite?". My answer is Yes we can integrate QlikView with MS office products like Excel, Power Point, MS Word , Outlook Express etc.

The easiest way to integrate is using OCX Components. With earlier versions of QlikView it was required to register OCX components at each user machines but with new 8.5.xx version it is not required to register OCX components. I will take excel as an example.

There may be two kind of users, first the person who is having QlikView licenses in his machine and second who don't have QlikView licenses (Thus he cannot use OCX capabilities). First kind of user can easily drag and drop QlikView objects in Excel sheet and he can use dynamic capabilities of reports in 100 % same way as he can do in QlikView itself. But if he needs to send these reports in excel to third party i.e. users of second kind who does not own QlikView licenses then what he need to do? Traditionally one can export data to excel from QlikView but it converts dynamic reports in static one and it is not acceptable everywhere.

What is the solution for above problem??

Solution is writing macro. One can write a macro in QlikView that will integrate QVW file to excel and whatever analysis based on clicks can be mapped directly to excel. Actually that macro can write a parallel program in excel and since data is available in QlikView application a click can push data with filters in excel and that excel can be shared to any one and it would remain dynamic even if user is not owning QlikView licenses.

Same way one can integrate QlikView with MS outlook or with any MS office product.

In next blog I will cover how effectively PDFs can be used to share QlikView reports to n number of users automatically.

I invite my readers comments.