PacktLib: QlikView 11 for Developers

QlikView 11 for Developers

Credits

Foreword

About the Authors

Acknowledgements

About the Reviewers

www.PacktPub.com

Preface

Meet QlikView

What is QlikView?

Exploring data with QlikView

The technology and components behind QlikView

Meet HighCloud Airlines

Summary

Seeing is Believing

What is a SiB?

Preparing the workspace

Creating the app

Summary

Data Sources

Using ODBC and OLE DB drivers

Accessing custom data sources

Reading table files

Extracting data—two hands-on examples

QVD and QVX files

Loading an Inline table

Summary

Data Modeling

Dimensional data modeling

The associative data model

The Table Viewer window

Summary

Styling Up

Design requirements

The Document Properties window

The Sheet Properties dialog

Setting the object properties

Working with listboxes

The Multi Box

The Current Selections Box

Adding a Bookmark Object

Aligning and resizing sheet objects

Creating and applying a default color map

Summary

Building Dashboards

User types

Applying the DAR principle to Airline Operations

Creating the Analysis sheet

Creating the new Dashboard sheet

Creating the Reports sheet

Other charts

Summary

Scripting

The Script Editor

Script statements

Conditional functions

Dealing with different data types

Debugging script

Standardizing and organizing script

Re-using scripts

Managing file locations and connection strings

Summary

Data Modeling Best Practices

Data consistency

Reducing storage requirements

Design challenges of data modeling

The master calendar

A final note on data modeling

Summary

Basic Data Transformation

Changing the source table structure

Summary

Advanced Expressions

Using variables

Using the TOTAL qualifier

The Aggr function

Conditional functions

A tip on copying expressions

Summary

Set Analysis and Point In Time Reporting

The magic of Set Analysis

Point In Time Reporting

Comparative analysis with alternate states

Always validate

Summary

Advanced Data Transformation

Data architecture

Loading data already stored in QlikView

Aggregating data

Sorting tables

The Peek function

Merging forces

Dealing with slowly changing dimensions

Ordering, peeking, and matching all at once

Incremental loads

Summary

More on Visual Design and User Experience

Creating a consistent QlikView UI

Additional interactivity

Summary

Security

Hidden script

Section access

Document-level security

Sheet-level security

Summary

Index