I am trying to to put QV charts into a Powerpoint slide and have them update automatically when the associated chart is updated in QlikView.
It sounds like this is what you were able to do....can you explain how you did it? The reference manual only says to install the QlikView IE plug-in. There is no info as to HOW to do that...or where the plug-in resides to download it from.
Can you shed any light on this?
Basically this option should become available when you install the QlikView Desktop application.
To sketch our final solution somewhat:
- we created an application to hold the used objects and their respective data
- this application is scheduled to reload overnight on our server
- When building the slide show in powerpoint, I had my QlikView desktop open the application in server. (See File -> Open in server)
- By copying the needed objects within QlikView desktop as 'Objects', I could simply paste them into the presentation. They should become OCX objects automatically.
- Whenever I open the presentation, the OCX plugin automatically tries to connect to our QlikView server (depending on the infrastructure available, number of objects used, data size,.. this can take a while) and fetches the latest object version with up to date data.
Hope this helps you out!
To do this, your application needs to reside on a QlikView server.
If I remember right, this system doesn't work when using a local dasboard on your local computer.
Since you don't know about the IE plugin (something available on the server access point), I guess this is your main problem.
If you have a server available, (have) deploy your dashboard on it, and copy the objects through the use of the web based IE plugin or using the "Open in server..." option within the desktop application.
In reply to my own thread, I'd like to point out we sourced the original problem not being due to the use of powerpoint and QlikView sessions as we thought at first.
This rather came through both the Windows password vault retaining conflicting certificates as well as JIRA (ticketing system) retaining an old password in IE history.