QlikView Scripting

For basic or intermediate developers, this book will give you a comprehensive understanding of QlikView, allowing tremendous speed and flexibility when it comes to scripting for data visualization. Great for reference too!

QlikView Scripting

Progressing
Matt Floyd

For basic or intermediate developers, this book will give you a comprehensive understanding of QlikView, allowing tremendous speed and flexibility when it comes to scripting for data visualization. Great for reference too!
$20.99
$34.99
RRP $20.99
RRP $34.99
eBook
Print + eBook
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
+ Collection
Free sample

Book Details

ISBN 139781782171669
Paperback138 pages

About This Book

  • Understand everything about QlikView, from structuring a script to fixing it to charting object problems
  • Packed full of information and code examples to help you to understand the key concepts and features of QlikView
  • Informative screenshots help you navigate QlikView’s scripting menus and dialogs

Who This Book Is For

If you are a basic orintermediate developer with some knowledge of QlikView applications and a basic understanding of QlikView scripting and data extraction and manipulation, this book will be great for you. If you are an advanced user, you can also use this book as a reference guide and teaching aid. If you are a QlikView project team member such as a business user, data/ETL professional, project manager, or systems analyst, you can also benefit from gaining an understanding of the structure and the challenges of writing an efficient and useful QlikView application.

Table of Contents

Chapter 1: Connecting to ODBC/OLE DB Data Sources
Installing drivers
Configuring ODBC
Connecting to the database from QlikView
Supported databases
Summary
Chapter 2: Creating the Script
Basics of data modeling
Accessing the Script Editor
Hidden scripts
The Script Editor features and commands
Script commenting
Creating the Select statement
Organizing tabs in scripts
Summary
Chapter 3: Data Transformations in Flat Files
Why data transformation?
Using the Transformation Wizard
Working with cross tables
Working with generic tables
Working with hierarchies
Summary
Chapter 4: Script Features and Functions
Number interpretation variables
Connect, Load, and other statement ordering
Script segmentation via tabs
Renaming fields
Regular statements and script control statements
Script expressions
Quotation marks
Master calendar placement
Summary
Chapter 5: Basic Data Model and Table Viewer
What is the Table Viewer?
Star and Snowflake Schemas
Data model best practices
Exporting images and structures
Viewing internal and source tables
Composite/synthetic tables and keys
Eliminating synthetic keys and tables
Previewing records in tables
Information density and subset ratios
Summary
Chapter 6: Advanced Scripting and Data Model Optimization
Circular references
Fixing circular references and removing synthetic tables
Using mapping tables to rename fields
Table combining and concatenation
The IntervalMatch function
Data islands
Using metadata
Summary
Chapter 7: QlikView Data Files
Defining a QVD
Advantages of QVDs
Creating QVDs
Creating QVDs with QlikView Publisher
Loading from QVDs
Viewing content of QVDs
Managing reload or no data opens of QVWs
Summary
Chapter 8: Debugging
QlikView script debugger
Using the Exit Script function
Using syntax checker
Common QlikView script errors
Debugging using logfiles
Using find/replace in debugging
Removing or partially loading data
Summary
Chapter 9: Layout Tips for Developers
Your KPI story
Layout consistency
Layout best practices
Optimizing your QlikView application user interface
Using themes for a consistent look
Dimension limits
Color alerts and calculated colors
Alternate states
Set analysis
Summary

What You Will Learn

  • Connect to various data sources, from external files to OLEDB/ODBC databases
  • Develop and structure a QlikView script
  • Transform data while loading from an external script
  • Discover the QlikView data modeling theory and the importance of structuring the data model
  • Optimize the data model through the use of table join concatenations, key tables, interval matching, and other useful scripting features
  • Use the QlikView Table Viewer to help you structure your data model
  • Create, use, and view information contained in QlikView data files (QVDs)
  • Debug QlikView scripts and fix problems using the syntax checker, logs, and the QlikView Debugger
  • Leverage dimensions and expressions in QlikView chart objects in the presentation layer
  • Understand common and useful QlikView script functions and expressions

In Detail

QlikView is a powerful business intelligence and data discovery platform that allows people to quickly develop relevant data visualization applications for business users. The relative ease of QlikView development—including backend scripting—allows applications to be developed rapidly, and allows for more collaboration in application development for business users.

A comprehensive guide that offers QlikView developers a rich discussion of scripting topics, from basic to advanced concepts, features, and functions in a compact mini-book format. This book allows developers to quickly gain confidence in understanding and expanding their QlikView scripting knowledge, and serves as a springboard for even more advanced topics in QlikView scripting.

The book starts off by covering basic topics such as connecting to data sources, scripting, dealing with load statements, data transformations, and the concepts of the basic data model. It then dives into advanced concepts such as advanced scripting and data model optimization, the creation and use of QlikView datafiles, debugging, and essential functions and features. It also provides layout tips for developers. Qlikview Scripting is a great overview and reference guide for beginner to intermediate Qlikview developers.

Authors

Table of Contents

Chapter 1: Connecting to ODBC/OLE DB Data Sources
Installing drivers
Configuring ODBC
Connecting to the database from QlikView
Supported databases
Summary
Chapter 2: Creating the Script
Basics of data modeling
Accessing the Script Editor
Hidden scripts
The Script Editor features and commands
Script commenting
Creating the Select statement
Organizing tabs in scripts
Summary
Chapter 3: Data Transformations in Flat Files
Why data transformation?
Using the Transformation Wizard
Working with cross tables
Working with generic tables
Working with hierarchies
Summary
Chapter 4: Script Features and Functions
Number interpretation variables
Connect, Load, and other statement ordering
Script segmentation via tabs
Renaming fields
Regular statements and script control statements
Script expressions
Quotation marks
Master calendar placement
Summary
Chapter 5: Basic Data Model and Table Viewer
What is the Table Viewer?
Star and Snowflake Schemas
Data model best practices
Exporting images and structures
Viewing internal and source tables
Composite/synthetic tables and keys
Eliminating synthetic keys and tables
Previewing records in tables
Information density and subset ratios
Summary
Chapter 6: Advanced Scripting and Data Model Optimization
Circular references
Fixing circular references and removing synthetic tables
Using mapping tables to rename fields
Table combining and concatenation
The IntervalMatch function
Data islands
Using metadata
Summary
Chapter 7: QlikView Data Files
Defining a QVD
Advantages of QVDs
Creating QVDs
Creating QVDs with QlikView Publisher
Loading from QVDs
Viewing content of QVDs
Managing reload or no data opens of QVWs
Summary
Chapter 8: Debugging
QlikView script debugger
Using the Exit Script function
Using syntax checker
Common QlikView script errors
Debugging using logfiles
Using find/replace in debugging
Removing or partially loading data
Summary
Chapter 9: Layout Tips for Developers
Your KPI story
Layout consistency
Layout best practices
Optimizing your QlikView application user interface
Using themes for a consistent look
Dimension limits
Color alerts and calculated colors
Alternate states
Set analysis
Summary

Book Details

ISBN 139781782171669
Paperback138 pages
Read More