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?
Summary
Chapter 3. Seeing is Believing
What is a SiB?
Preparing the workspace
Creating the app
Summary
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
Summary
Chapter 5. Data Modeling
Dimensional data modeling
The associative data model
The Table Viewer window
Summary
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
Summary
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
Summary
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
Summary
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
Summary
Chapter 10. Basic Data Transformation
Changing the source table structure
Summary
Chapter 11. Advanced Expressions
Using variables
Using the TOTAL qualifier
The Aggr function
Conditional functions
A tip on copying expressions
Summary
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
Summary
Chapter 13. 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
Chapter 14. More on Visual Design and User Experience
Creating a consistent QlikView UI
Additional interactivity
Summary
Chapter 15. Security
Hidden script
Section access
Document-level security
Sheet-level security
Summary
Index
更新时间：2021-07-09 18:58:48
完结共119章
倒序