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.
Load the following script:
LOAD * INLINE [ Country, Sales UK, 100000 USA, 101899 Japan, 87088 Germany, 67896 ];
The following steps explain how to extract QlikView data to a Word report:
Countryas dimension. Add the following expression: ...