| Description |
1 online resource (iv, 272 pages) : illustrations (chiefly color) |
| Physical Medium |
polychrome |
| Description |
text file |
| Note |
"Quick answers to common problems"--Cover. |
|
Includes index. |
| Contents |
Cover; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Charts; Introduction; Creating custom pop up labels on 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 chartCreating 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; Chapter 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 on QlikView Server; Using containers as an alternative to multi-boxes. |
|
Using the design menus to custom format a cellChapter 3: Set Analysis; Introduction; Using dollar expansion in Set Analysis to enable from-date and to-date selection; Using alternate states with Set Analysis; Using Set operators to exclude values from results; Using Set Analysis with a Date Island; Using Sets to avoid key tables; Chapter 4: Advanced Aggregations; Introduction; Using TOTAL to calculate the percentage of total and the percentage of 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 ExpansionUsing 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 multi-dimension 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; Chapter 5: Advanced Coding; Introduction; Extracting QlikView data to a Word report; Printing reports to PDF using PDFCreator. |
|
Creating a chart using a macroUsing VBS functions in charts; Chapter 6: Data Modeling; Introduction; Concatenation of fact tables to avoid loops and synthetic keys; Creating a Key/Link table in QlikView; Chapter 7: Extensions; Introduction; Creating a simple HTML extension; Creating a simple HTML table; Creating an interactive extension; Using external libraries with extensions; Chapter 8: Useful Functions; Introduction; Handling null in numeric fields or calculations; Using Dual to handle period name sort; Parsing text to numbers and dates; Calculating Year To Date dynamically. |
| Summary |
The recipes in this Cookbook provide a concise yet practical guide on how to become an excellent QlikView developer. The book begins with intermediate level recipes and then moves on to more complex recipes in an incremental manner. This book is for anyone who has either attended QlikView Developer training or has taught themselves QlikView from books or online sources. You might be working for a QlikView customer, partner, or even QlikView themselves (or want to!) and want to improve your QlikView skills. |
| Access |
Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK). WlAbNL |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Terms Of Use |
Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force. WlAbNL |
| Subject |
Application software -- Development.
|
|
Application software -- Development. |
|
Business intelligence.
|
|
Business intelligence. |
| Genre/Form |
Electronic books.
|
| Other Form: |
Print version: Redmond, Stephen. QlikView for Developers Cookbook. Birmingham : Packt Publishing, ©2013 9781782179733 |
| ISBN |
9781782179740 (e-book) |
|
1782179747 (e-book) |
|
1782179739 |
|
9781782179733 |
|
9781782179733 |
|
