QlikView for Developers Cookbook

Stephen Redmond

• Publisher: Packt Publishing
• Year: 2013
• Edition: 1
• eBook ISBN:
  9781782179733
• Topic: Computer Science
• Subtopic: Business Intelligence
• Index: Computer Science

In Detail

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.

Approach

The recipes in this Cookbook provide a concise yet practical guide on how to become an excellent QlikView developer. The book begins with intermediate level recipes and then moves on to more complex recipes in an incremental manner.

Who this book is for

This book is for anyone who has either attended QlikView Developer training or has taught themselves QlikView from books or online sources. You might be working for a QlikView customer, partner, or even QlikView themselves (or want to!) and want to improve your QlikView skills.

QlikView for Developers Cookbook

---

Table of Contents

QlikView for Developers Cookbook

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Charts

Introduction

Creating custom pop-up labels on a bar chart

Getting ready

How to do it…

How it works…

There's more…

Creating a box plot chart for a simple data set

Getting ready

How to do it…

How it works…

There's more…

See also

Using the wizard to create a box plot chart

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a "Stephen Few" bullet chart

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a modified bullet chart in a straight table

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a bar chart in a straight table

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a Redmond Aged Debt Profile chart

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a waterfall chart

Getting ready

How to do it…

How it works…

There's more…

Replacing the legend in a line chart with labels on each line

Getting ready

How to do it…

How it works…

There's more…

See also

Creating a secondary dimension in a bar chart

Getting ready

How to do it…

How it works…

There's more…

Creating a line chart with variable width lines

Getting ready

How to do it…

How it works…

There's more…

Brushing parallel coordinates

Getting ready

How to do it…

How it works…

There's more…

See also

Using redundant encoding with a scatter chart

Getting ready

How to do it…

How it works…

There's more…

Staggering labels in a pie chart

Getting ready

How to do it…

How it works…

There's more…

Creating dynamic ad hoc analysis in QlikView

Getting ready

How to do it…

How it works…

There's more…

2. Layout

Introduction

Changing the default object layout options

Getting ready

How to do it…

How it works…

See also

Changing the default selection color scheme

Getting ready

How to do it…

How it works…

There's more…

See also

Modifying the green, white, and gray selection color schemes

Getting ready

How to do it

How it works…

There's more…

See also

Modifying the green, white, and gray selection color schemes in QlikView Server

Getting ready

How to do it…

How it works…

See also

Using containers as an alternative to multiboxes

Getting ready

How to do it…

How it works…

Using the design menus to custom format a cell

Getting ready

How to do it…

How it works…

There's more…

3. Set Analysis

Introduction

Using dollar expansion in Set Analysis to enable from-date and to-date selection

Getting ready

How to do it...

How it works...

Using alternate states with Set Analysis

Getting ready

How to do it...

How it works...

There's more...

See Also

Using Set operators to exclude values from results

Getting ready

How to do it...

How it works...

There's more...

Using Set Analysis with a Date Island

Getting ready

How to do it...

How it works...

There's more...

See Also

Using Sets to avoid key tables

Getting ready

How to do it...

How it works...

There's more...

4. Advanced Aggregations

Introduction

Using TOTAL to calculate the percentage of total and subtotal

Getting ready

How to do it...

How it works...

There's more...

Using AGGR to calculate the percentage of the maximum value

Getting ready ...

Table of contents

• QlikView for Developers Cookbook