更新时间：2021-07-09 18:58:48
coverpage
QlikView for Developers
Credits
About the Authors
Acknowledgements
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Meet QlikView
What is QlikView?
Exploring data with QlikView
The technology and components behind QlikView
Meet HighCloud Airlines
Summary
Chapter 2. What's New in QlikView 12?
How is QlikView 12 different from QlikView 11?
What is new in the Qlik product portfolio?
How do the products in the Qlik product portfolio fit together?
What is new in QlikView 12 for Developers?
Chapter 3. Seeing is Believing
What is a SiB?
Preparing the workspace
Creating the app
Chapter 4. Data Sources
Using ODBC and OLE DB drivers
Extracting data – two hands-on examples
Loading a table file
QVD and QVX files
Loading an Inline table
Chapter 5. Data Modeling
Dimensional data modeling
The associative data model
The Table Viewer window
Chapter 6. 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
Chapter 7. 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
Chapter 8. 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
Chapter 9. Data Modeling Best Practices
Data consistency
Reducing storage requirements
Design challenges of data modeling
The master calendar
A final note on data modeling
Chapter 10. Basic Data Transformation
Changing the source table structure
Chapter 11. Advanced Expressions
Using variables
Using the TOTAL qualifier
The Aggr function
A tip on copying expressions
Chapter 12. Set Analysis and Point In Time Reporting
The magic of Set Analysis
Point In Time Reporting
Comparative analysis with alternate states
Always validate
Chapter 13. Advanced Data Transformation
Data architecture
Loading data already stored in QlikView
