O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

QlikView Scripting

Book Description

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!

  • Understand everything about QlikView, from structuring a script to fixing it to charting object problems
  • Packed full of information and code examples to help you to understand the key concepts and features of QlikView
  • Informative screenshots help you navigate QlikView’s scripting menus and dialogs

In Detail

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

  1. QlikView Scripting
    1. Table of Contents
    2. QlikView Scripting
    3. Credits
    4. About the Author
    5. About the Reviewers
    6. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why Subscribe?
        2. Free Access for Packt account holders
        3. Instant Updates on New Packt Books
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    8. 1. Connecting to ODBC/OLE DB Data Sources
      1. Installing drivers
      2. Configuring ODBC
      3. Connecting to the database from QlikView
      4. Supported databases
      5. Summary
    9. 2. Creating the Script
      1. Basics of data modeling
      2. Accessing the Script Editor
      3. Hidden scripts
      4. The Script Editor features and commands
        1. The File menu
        2. The Edit menu
        3. The Insert menu
        4. The Tab menu
        5. The Tools menu
        6. The Help menu
        7. The Tools pane
      5. Script commenting
      6. Creating the Select statement
        1. Connecting to the database
        2. Building the Select statement
        3. Running your script and viewing results
      7. Organizing tabs in scripts
      8. Summary
    10. 3. Data Transformations in Flat Files
      1. Why data transformation?
      2. Using the Transformation Wizard
        1. Removing garbage from data files
        2. Using the Fill function
        3. Unwrapping data from repeating columns
        4. Column manipulation
        5. Transformation script results
        6. Rotating tables
      3. Working with cross tables
      4. Working with generic tables
      5. Working with hierarchies
      6. Summary
    11. 4. Script Features and Functions
      1. Number interpretation variables
      2. Connect, Load, and other statement ordering
      3. Script segmentation via tabs
      4. Renaming fields
        1. The AS specifier
        2. The Alias statement
        3. The Rename Field statement
        4. The QUALIFY statements
      5. Regular statements and script control statements
      6. Script expressions
      7. Quotation marks
      8. Master calendar placement
      9. Summary
    12. 5. Basic Data Model and Table Viewer
      1. What is the Table Viewer?
      2. Star and Snowflake Schemas
      3. Data model best practices
      4. Exporting images and structures
      5. Viewing internal and source tables
      6. Composite/synthetic tables and keys
      7. Eliminating synthetic keys and tables
      8. Previewing records in tables
      9. Information density and subset ratios
      10. Summary
    13. 6. Advanced Scripting and Data Model Optimization
      1. Circular references
      2. Fixing circular references and removing synthetic tables
      3. Using mapping tables to rename fields
      4. Table combining and concatenation
      5. The IntervalMatch function
      6. Data islands
      7. Using metadata
      8. Summary
    14. 7. QlikView Data Files
      1. Defining a QVD
      2. Advantages of QVDs
      3. Creating QVDs
        1. Full loads of QVDs
        2. QVD incremental loads
      4. Creating QVDs with QlikView Publisher
      5. Loading from QVDs
      6. Viewing content of QVDs
      7. Managing reload or no data opens of QVWs
      8. Summary
    15. 8. Debugging
      1. QlikView script debugger
      2. Using the Exit Script function
      3. Using syntax checker
      4. Common QlikView script errors
      5. Debugging using logfiles
      6. Using find/replace in debugging
      7. Removing or partially loading data
      8. Summary
    16. 9. Layout Tips for Developers
      1. Your KPI story
      2. Layout consistency
      3. Layout best practices
      4. Optimizing your QlikView application user interface
      5. Using themes for a consistent look
        1. Creating a new QlikView theme
        2. Applying themes
        3. Containers
      6. Dimension limits
      7. Color alerts and calculated colors
        1. Using visual cues
      8. Alternate states
      9. Set analysis
        1. Set analysis syntax
        2. Set identifier
        3. Set operators
        4. Set modifiers
      10. Summary
    17. Index