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

Matt Floyd

1 customer reviews
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!
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $20.99
Save 52%
Print + eBook
$34.99
RRP $34.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$34.99
$29.99p/m after trial
RRP $20.99
RRP $34.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Preview in Mapt

Book Details

ISBN 139781782171669
Paperback138 pages

Book Description

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.

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

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
From 1 reviews

Read More Reviews

Recommended for You

QlikView for Developers Cookbook Book Cover
QlikView for Developers Cookbook
$ 26.99
$ 10.00
Learning QlikView Data Visualization Book Cover
Learning QlikView Data Visualization
$ 22.99
$ 10.00
QlikView 11 for Developers Book Cover
QlikView 11 for Developers
$ 35.99
$ 10.00
Mastering QlikView Book Cover
Mastering QlikView
$ 35.99
$ 10.00
Creating Stunning Dashboards with QlikView Book Cover
Creating Stunning Dashboards with QlikView
$ 31.99
$ 10.00
QlikView 11 para Desarrolladores (Espanol) Book Cover
QlikView 11 para Desarrolladores (Espanol)
$ 35.99
$ 10.00