Skip to Main Content
QlikView for Developers Cookbook
book

QlikView for Developers Cookbook

by Stephen Redmond
June 2013
Beginner to intermediate content levelBeginner to intermediate
290 pages
4h 59m
English
Packt Publishing
Content preview from QlikView for Developers Cookbook

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: ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

QlikView for Developers

QlikView for Developers

Miguel Angel Garcia, Barry Harmsen
QlikView 11 for Developers

QlikView 11 for Developers

Miguel Angel Garcia, Barry Harmsen

Publisher Resources

ISBN: 9781782179733Other