topic Create a document with data and text from other MS-Word / Excel files in QlikView

Create a document with data and text from other MS-Word / Excel files

Wed, 18 Nov 2009 17:06:15 GMT

Hello, I'm trying to make a nice document for our management. Through the document functionality in Qlikview I can make a nice data document. Now I want to include various other data as text and images to make the document complete.

In old times I ran a Macro in MS-Excel to include word en excel files into 1 pdf but now I want to do the same with Qlikview. Is this possible and how to do this?

Regards,

Richard

Create a document with data and text from other MS-Word / Excel files

Wed, 18 Nov 2009 17:10:18 GMT

There is different ways,

You can create a word document and include a Qlikview object. In this case, you don't need specific code, but the objects in word / excel will be objects qlikview ( person must have access to the application).

Or you can create a macro that will export needed charts into pictures. Then the pictures will be updated in a word document. Everything can be done by a macro.

Rgds,

Sébastien

Create a document with data and text from other MS-Word / Excel files

Wed, 18 Nov 2009 18:11:27 GMT

How can I include a Qlikview object into a Word doc?

Can I refresh it or do I have to copy/paste the object every week?

Create a document with data and text from other MS-Word / Excel files

rwunderlich — Thu, 19 Nov 2009 05:46:57 GMT

You can drag Qlikview objects from Qlikview and drop them into office documents. The Qlikview Plugin must be installed on the computer.

-Rob