Book description
Take your QlikView training to the next level with this brilliant book that’s packed with recipes which progress from intermediate to advanced. The step-by step-approach makes learning easy and enjoyable.
- Learn beyond QlikView training
- Discover QlikView Advanced GUI development, advanced scripting, complex data modelling issues, and much more
- Accelerate the growth of your QlikView developer ability
- Based on over 7 years’ experience of QlikView development
- Written in a handy Cookbook style with each recipe as a self-contained learning module
In Detail
QlikView has been around since 1993, but has only really taken off in recent years as a leader in the in-memory BI space and, more recently, in the data discovery area. QlikView features the ability to consolidate relevant data from multiple sources into a single application, as well as an associative data model to allow you to explore the data to a way your brain works, state-of-the-art visualizations, dashboard, analysis and reports, and mobile data access.
QlikView for Developers Cookbook builds on your initial training and experiences with QlikView to help you become a better developer. This book features plenty of hands-on examples of many challenging functions.
Assuming a basic understanding of QlikView development, this book provides a range of step-by-step exercises to teach you different subjects to help build your QlikView developer expertise.
From advanced charting and layout to set analysis; from advanced aggregations through to scripting, performance, and security, this book will cover all the areas that you need to know about.
The recipes in this book will give you a lot of the information that you need to become an excellent QlikView developer.
Table of contents
-
QlikView for Developers Cookbook
- Table of Contents
- QlikView for Developers Cookbook
- Credits
- Foreword
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Charts
- Introduction
- Creating custom pop-up labels on a bar chart
- Creating a box plot chart for a simple data set
- Using the wizard to create a box plot chart
- Creating a "Stephen Few" bullet chart
- Creating a modified bullet chart in a straight table
- Creating a bar chart in a straight table
- Creating a Redmond Aged Debt Profile chart
- Creating a waterfall chart
- Replacing the legend in a line chart with labels on each line
- Creating a secondary dimension in a bar chart
- Creating a line chart with variable width lines
- Brushing parallel coordinates
- Using redundant encoding with a scatter chart
- Staggering labels in a pie chart
- Creating dynamic ad hoc analysis in QlikView
-
2. Layout
- Introduction
- Changing the default object layout options
- Changing the default selection color scheme
- Modifying the green, white, and gray selection color schemes
- Modifying the green, white, and gray selection color schemes in QlikView Server
- Using containers as an alternative to multiboxes
- Using the design menus to custom format a cell
- 3. Set Analysis
-
4. Advanced Aggregations
- Introduction
- Using TOTAL to calculate the percentage of total and subtotal
- Using AGGR to calculate the percentage of the maximum value
- Using AGGR to resolve a "Sum of Rows" issue
- Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion
- Using RangeMax to return only positive numbers
- Creating a dynamic Part-to-Whole pie chart
- Creating a colored treemap using colormix
- Using RangeSum to calculate a rolling total in a multidimension table
- Showing only the top 3 values in a pivot table
- Creating a Statistical Control Chart using Standard Deviation
- Creating a Moving Range chart
- Creating a control chart using Moving Range
- 5. Advanced Coding
- 6. Data Modeling
- 7. Extensions
-
8. Useful Functions
- Introduction
- Handling null in numeric fields or calculations
- Using Dual to handle period name sorting
- Parsing text to numbers and dates
- Calculating Year To Date dynamically
- Labeling a pie chart to replace the legend
- Calculating the lowest or highest value in a range
- Consolidating a date-time value into quarter hourly segments
- Dynamically filtering by From/To dates
-
9. Script
- Introduction
- Creating flags in the script
- Replacing IsNull
- Storing and dropping using a subroutine
- Keeping a trace on things
- Using the AND mode in listboxes
- Using Exists and Keep to limit the data load
- Setting the default display format
- Setting the default sort order
- Matching financial periods to dates
- Handling partial reload in the script
- Using Peek and Previous to calculate against loaded records
- Creating a simple Gantt for a dashboard using Interval Match
- Reading users from Active Directory
- Getting a sub-URL using the Table wizard
- Using parameters in Dollar Sign Expansion
- Removing fields with a wildcard
- Handling multiple subfolders in a script
- 10. Improving Performance
- 11. Security
- Index
Product information
- Title: QlikView for Developers Cookbook
- Author(s):
- Release date: June 2013
- Publisher(s): Packt Publishing
- ISBN: 9781782179733
You might also like
book
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Modern Python Cookbook - Second Edition
Complete recipes spread across 15 chapters to help you overcome commonly faced issues by Python for …
book
QlikView Essentials
Want to solve your Business Intelligence headaches? Learn how QlikView can help, and discover a powerful …
book
Power Query Cookbook
Leverage your source data from hundreds of different connections, perform millions of different transformations, and easily …
