QlikView Scripting


QlikView Scripting
eBook: $20.99
Formats: PDF, PacktLib, ePub and Mobi formats
$17.84
save 15%!
Print + free eBook + free PacktLib access to the book: $55.98    Print cover: $34.99
$34.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 138 pages [ 235mm x 191mm ]
Release Date : November 2013
ISBN : 1782171665
ISBN 13 : 9781782171669
Author(s) : Matt Floyd
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise

Table of Contents

Preface
Chapter 1: Connecting to ODBC/OLE DB Data Sources
Chapter 2: Creating the Script
Chapter 3: Data Transformations in Flat Files
Chapter 4: Script Features and Functions
Chapter 5: Basic Data Model and Table Viewer
Chapter 6: Advanced Scripting and Data Model Optimization
Chapter 7: QlikView Data Files
Chapter 8: Debugging
Chapter 9: Layout Tips for Developers
Index
    • Chapter 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
      • Chapter 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
        • Chapter 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
          • Chapter 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
              • Chapter 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
                • Chapter 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
                  • Chapter 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

                    Matt Floyd

                    Matt Floyd has worked in the software industry since 2000, and has held career titles ranging from Project Manager to Technical Writer to Business Intelligence analyst. His career has spanned many industries, including environmental, healthcare, pharmaceutical, and insurance. Matt's hands-on experience with QlikView started in 2008 with documenting an OEM-healthcare-related QlikView application for several years. Since then, he has been a technical writer, implementation engineer, consultant, and developer on QlikView projects. His passion for QlikView stems from his fascination of discovery through data, and the art, science, and power of data visualization. He is the founder of the Atlanta QlikView User Group and lives with his family in metropolitan Atlanta. Matt can be followed on his blog where he covers mostly QlikView-related Business Intelligence topics at floydmatt.com.
                    Sorry, we don't have any reviews for this title yet.

                    Code Downloads

                    Download the code and support files for this book.


                    Submit Errata

                    Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                    Errata

                    - 12 submitted: last submission 20 Jan 2014

                    Errata Type: Language | Page number: 59

                     

                    Instead of

                    There is a great third-party tool for doing just that: QViewer, or EasyQlik is a very fast and small footprint standalone file viewer for analyzing the  QVD  files.

                     

                    It should be

                    There is a great third-party tool for doing just that: QViewer is a very fast and small footprint standalone file viewer for analyzing the  QVD  files.

                    Errata Type: Typo | Page number: 92

                     

                    Instead of

                    This file, with the default name qv.log, is stored in the same folder in which the current QlikView application is.

                     

                    It should be

                    This file, with the default name qvw.log, is stored in the same  folder in which the current QlikView application is.

                    Errata Type: Technical | Page number: 11

                     

                    Instead of


                    Binary loading will not be allowed in any applications with a hidden script.

                     

                    It should be


                    Binary loading will be allowed with an exception that the code for the hidden script of the binary load will be the first tab in the main script.

                     

                    Errata Type: Technical | Page number: 85

                     

                    Instead of


                    Note that if your QVD is very large, you should do a partial reload, restrict via dimension limits, create a condition on the expression, or create a calculated limitation for the expression that would limit the rows that are returned.

                     

                    It should be


                    Note that, to limit the number of records loaded, you either add a Where clause or use the First or Sample prefixes with appropriate arguments.

                    Errata Type: Technical | Page number: 39

                     

                    Instead of

                    A QlikView script contains several sections that are mandatory (number interpretation variables, script expressions, and load scripts) and some that are optional (master calendar and variables).

                    It should be


                    A QlikView script contains several sections such as number interpretation variables, script expressions, and load scripts, and some
                    that are optional such as master calendar and variables.

                    Errata Type: Technical | Page number: 70

                     

                    Instead of

                    Because we did not specify the table name to concatenate it to in the Concatenate statement (Concatenate TableName is the best practice), the statement appends the rows from Electronics.csv onto the last table created (Toys).

                     

                    It should be

                    Because we did not specify the table name to concatenate it to in the Concatenate statement (Concatenate (TableName) is the best practice), the statement appends the rows from Electronics.csv onto the last table created (Toys).


                    Errata Type: Technical | Page number: 92

                     

                    Instead of


                    There are instances when a load script will fail silently. Attempting to store a QVD or CSV to a file that is locked by another user viewing it is one such error. Another example is when you have two fields with the same name in your load statement.

                     

                    It should be


                    There are instances when a load script will fail silently. Attempting to store a QVD or CSV to a file that is locked by another user viewing it is one such error. Using a field name twice in a load statement result in an error message: Field names must be unique within table.

                    Errata Type: Technical | Page number: 18

                     


                    Instead of

                    4. Select Microsoft Office 12.0 Access Database Engine. On older systems or to access older Access.mdb databases, select the Microsoft Jet 4.0 OLE DB driver.

                     

                    It should be


                    4. Select Microsoft Office 12.0 Access Database Engine.


                    Errata Type: Technical | Page number: 48

                     

                    Instead of


                    Fields and records are contained in files (also known as QVDs).

                     

                    It should be

                    Fields and records are contained in files and data sources (such as QVDs and QVWs).

                    Errata Type: Layouts | Page number: 73

                     

                    Instead of

                     

                    Then, we can add some data about the call center, via an inline load:

                    call center, via an inline load:
                    [Call Center Log]:
                    LOAD * INLINE [
                    dateid, calls, call_time_minutes
                    1, 1000, 200
                    2, 1500, 300
                    3, 2000, 400
                    ];

                     

                    It should be

                     

                    Then, we can add some data about the call center, via an inline load:

                    [Call Center Log]:
                    LOAD * INLINE [
                    dateid, calls, call_time_minutes
                    1, 1000, 200
                    2, 1500, 300
                    3, 2000, 400
                    ];

                    Kindle location: 108

                     

                    Instead of

                    Toys:
                    Load Product_ID, Product_Name, Category from Toys.csv;
                    Noconcatenate Load Product_ID, Product_Name, Category fromElectronics.csv

                     

                    It should be

                    Toys:
                    Load Product_ID, Product_Name, Category from Toys.csv;
                    Noconcatenate Load Product_ID, Product_Name, Category from Electronics.csv

                     

                    Kindle location: 111

                     

                    Instead of

                     

                    Then, we can add some data about the call center, via an inline load:

                    call center, via an inline load:
                    [Call Center Log]:
                    LOAD * INLINE [
                    dateid, calls, call_time_minutes
                    1, 1000, 200
                    2, 1500, 300
                    3, 2000, 400
                    ];

                     

                    It should be

                     

                    Then, we can add some data about the call center, via an inline load:

                    [Call Center Log]:
                    LOAD * INLINE [
                    dateid, calls, call_time_minutes
                    1, 1000, 200
                    2, 1500, 300
                    3, 2000, 400
                    ];

                    Sample chapters

                    You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                    Frequently bought together

                    QlikView Scripting +    Microsoft Visio 2010 Business Process Diagramming and Validation =
                    50% Off
                    the second eBook
                    Price for both: $35.99

                    Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                    What you will learn from this book

                    • Connect to various data sources, from external files to OLEDB/ODBC databases
                    • Develop and structure a QlikView script
                    • Transform data while loading from an external script
                    • Discover the QlikView data modeling theory and the importance of structuring the data model
                    • Optimize the data model through the use of table join concatenations, key tables, interval matching, and other useful scripting features
                    • Use the QlikView Table Viewer to help you structure your data model
                    • Create, use, and view information contained in QlikView data files (QVDs)
                    • Debug QlikView scripts and fix problems using the syntax checker, logs, and the QlikView Debugger
                    • Leverage dimensions and expressions in QlikView chart objects in the presentation layer
                    • Understand common and useful QlikView script functions and expressions

                    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.

                    Approach

                    This mini book offers information about QlikView scripting written in an easy-to-understand manner, and covers QlikView scripting from basic to advanced features in a compact format.

                    Who this book is for

                    If you are a basic orintermediate developer with some knowledge of QlikView applications and a basic understanding of QlikView scripting and data extraction and manipulation, this book will be great for you. If you are an advanced user, you can also use this book as a reference guide and teaching aid. If you are a QlikView project team member such as a business user, data/ETL professional, project manager, or systems analyst, you can also benefit from gaining an understanding of the structure and the challenges of writing an efficient and useful QlikView application.

                    Code Download and Errata
                    Packt Anytime, Anywhere
                    Register Books
                    Print Upgrades
                    eBook Downloads
                    Video Support
                    Contact Us
                    Awards Voting Nominations Previous Winners
                    Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                    Resources
                    Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software