Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Paste variable text into WORD based on Qlikview analyses

Dear all,

I would like to use my analyses from Qlikview into Word for reporting purposes, based on a Word template in which I can pasted text and charts from Qlikview in predefined areas. Is this possible or should I just copy and pasted the text from Qlikview?


Thanks in advance.


Regards,

Rishi

1 Reply
Highlighted
Luminary
Luminary

Paste variable text into WORD based on Qlikview analyses

Hi Rishi,

It would be possible but you need to write macros.

The macro code to copy a chart image to the clipboard is:


ActiveDocument.GetSheetObject("CH01").CopyBitmapToClipboard


Then you could write the appropriate code in Word's API to paste that at a Word Bookmark position.
Might be a lot of work, but worth it if it is something you will do on a regular basis.
Regards,
Stephen