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:

  1. Create a new bar chart with Country as dimension. Add the following expression: ...

Get QlikView for Developers Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.