Extracting QlikView data to a Word report
While there is a good report engine in QlikView, its output is limited to printing—either to an actual printer or to a PDF printer driver. If you want to get data into a different format, for example, Word, you can manually copy and paste charts and data, but it would be useful to have a different option.
In this recipe we will use the QlikView API to extract data and use the Word API to generate that data in a Word report.
Getting ready
Load the following script:
LOAD * INLINE [ Country, Sales UK, 100000 USA, 101899 Japan, 87088 Germany, 67896 ];
How to do it…
The following steps explain how to extract QlikView data to a Word report:
Create a new bar chart with
Country
as dimension. Add the following expression:Sum(Sales)
After clicking on Finish to save the chart, edit the properties and set the Object ID to
rptChart01
.From the Tools menu, select Edit Module….
Enter the following code:
Option Explicit Sub SendReportToWord() ' Word Table formats...