Book Image

QlikView for Developers Cookbook

By : Stephen Redmond
Book Image

QlikView for Developers Cookbook

By: Stephen Redmond

Overview of this book

QlikView has been around since 1993, but has only really taken off in recent years as a leader in the in-memory BI space and, more recently, in the data discovery area. QlikView features the ability to consolidate relevant data from multiple sources into a single application, as well as an associative data model to allow you to explore the data to a way your brain works, state-of-the-art visualizations, dashboard, analysis and reports, and mobile data access. QlikView for Developers Cookbook builds on your initial training and experiences with QlikView to help you become a better developer. This book features plenty of hands-on examples of many challenging functions. Assuming a basic understanding of QlikView development, this book provides a range of step-by-step exercises to teach you different subjects to help build your QlikView developer expertise. From advanced charting and layout to set analysis; from advanced aggregations through to scripting, performance, and security, this book will cover all the areas that you need to know about. The recipes in this book will give you a lot of the information that you need to become an excellent QlikView developer.
Table of Contents (19 chapters)
QlikView for Developers Cookbook
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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:

    Sum(Sales)
  2. After clicking on Finish to save the chart, edit the properties and set the Object ID to rptChart01.

  3. From the Tools menu, select Edit Module….

  4. Enter the following code:

    Option Explicit
    
    Sub SendReportToWord()
      ' Word Table formats...