封面
版权页
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
The QlikView Unlocked project
QlikView is huge
Qlik Community
LinkedIn
QlikView blogs
Books about QlikView
Service releases
Qlik events
Local groups
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Behind Every Successful Project Is a Plan
Why infrastructure is important
Environments and architecture
Building a reusable maintainable environment
QlikView projects need discipline too!
Can you deliver?
Summary
Chapter 2. Building the Correct Environment
Creating and enforcing site standards
Designing a site-style template
Making document names meaningful
Separation of responsibilities change management and thinking about security
Understanding the differences in environments
Summary
Chapter 3. Are You Sitting Comfortably? Be More Productive
A bit more about license types
Make yourself comfortable and productive
Never lose your work
Some useful global settings
Some best practices for developers
Hidden features – Easter eggs
A few do's and don'ts
Summary
Chapter 4. It's All About Understanding the Data
Understanding the data you're working with
Even a few list and table boxes tell you and the user a lot
Exciting users with a prototype then throwing it away
Dirty data and what to do about it
Is this the right place for this data?
Building a structure of QVD layers
Incremental loads and performance
Summary
Chapter 5. The Right Data Model Pays Dividends
Synthetic keys and why they're sometimes bad news
Link tables
Avoiding loops in the data model
Simplify simplify simplify – never have subtables that you don't need
Data islands single calendars and set analysis
Avoiding problems with JOIN
Summary
Chapter 6. Make It Easy on Yourself – Some QlikView Tips and Tricks
A few coding tips
Surprising data sources
Include files
Change logs
Calculations and flags in the script
Previous() and Peek() functions
Preceding load on preceding load
Finding min and max
Autonumber
Reading from a spreadsheet
Summary
Chapter 7. Improving Chart Performance and Usability
Don't forget screen performance
Cached expressions
Multiple selection criteria
Copying expressions
Reusing chart expressions
Hidden graphics
Making charts more readable
Resizing objects
Stopping objects from being moved
Defaulting the scroll bar to the right of a chart
Summary
Chapter 8. To Deployment and Beyond
Security and Section Access
Why server jobs fail
Deploying from development to UAT and on to production
The golden source
Why Publisher isn't always a good thing
Your two best friends
It will never be perfect but it will be close
Summary
Appendix A. Hidden Image List
Index
更新时间：2021-08-05 16:41:21
完结共98章
倒序