QlikView Scripting -- Table of Contents -- QlikView Scripting -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Connecting to ODBC/OLE DB Data Sources -- Installing drivers -- Configuring ODBC -- Connecting to the database from QlikView -- Supported databases -- Summary -- 2. Creating the Script -- Basics of data modeling -- Accessing the Script Editor -- Hidden scripts -- The Script Editor features and commands -- The File menu -- The Edit menu -- The Insert menu -- The Tab menu -- The Tools menu -- The Help menu -- The Tools pane -- Script commenting -- Creating the Select statement -- Connecting to the database -- Building the Select statement -- Running your script and viewing results -- Organizing tabs in scripts -- Summary -- 3. Data Transformations in Flat Files -- Why data transformation? -- Using the Transformation Wizard -- Removing garbage from data files -- Using the Fill function -- Unwrapping data from repeating columns -- Column manipulation -- Transformation script results -- Rotating tables -- Working with cross tables -- Working with generic tables -- Working with hierarchies -- Summary -- 4. Script Features and Functions -- Number interpretation variables -- Connect, Load, and other statement ordering -- Script segmentation via tabs -- Renaming fields -- The AS specifier -- The Alias statement -- The Rename Field statement -- The QUALIFY statements -- Regular statements and script control statements -- Script expressions -- Quotation marks.

Master calendar placement -- Summary -- 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 -- 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 -- 7. QlikView Data Files -- Defining a QVD -- Advantages of QVDs -- Creating QVDs -- Full loads of QVDs -- QVD incremental loads -- Creating QVDs with QlikView Publisher -- Loading from QVDs -- Viewing content of QVDs -- Managing reload or no data opens of QVWs -- Summary -- 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 -- 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 -- Creating a new QlikView theme -- Applying themes -- Containers -- Dimension limits -- Color alerts and calculated colors -- Using visual cues -- Alternate states -- Set analysis -- Set analysis syntax -- Set identifier -- Set operators -- Set modifiers -- Summary -- Index.