QlikView for Developers Cookbook

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 t...

Celý popis

Uloženo v:
Podrobná bibliografie
Hlavní autor: Redmond, Stephen
Médium: E-kniha
Jazyk:angličtina
Vydáno: Birmingham Packt Publishing, Limited 2013
Packt Publishing
Vydání:1
Témata:
Application software
Business intelligence
Development
ISBN:1782179739, 9781782179733
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
Obsah:
  • Getting ready -- How to do it… -- How it works… -- There's more… -- Brushing parallel coordinates -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Using redundant encoding with a scatter chart -- Getting ready -- How to do it… -- How it works… -- There's more… -- Staggering labels in a pie chart -- Getting ready -- How to do it… -- How it works… -- There's more… -- Creating dynamic ad hoc analysis in QlikView -- Getting ready -- How to do it… -- How it works… -- There's more… -- 2. Layout -- Introduction -- Changing the default object layout options -- Getting ready -- How to do it… -- How it works… -- See also -- Changing the default selection color scheme -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Modifying the green, white, and gray selection color schemes -- Getting ready -- How to do it -- How it works… -- There's more… -- See also -- Modifying the green, white, and gray selection color schemes in QlikView Server -- Getting ready -- How to do it… -- How it works… -- See also -- Using containers as an alternative to multiboxes -- Getting ready -- How to do it… -- How it works… -- Using the design menus to custom format a cell -- Getting ready -- How to do it… -- How it works… -- There's more… -- 3. Set Analysis -- Introduction -- Using dollar expansion in Set Analysis to enable from-date and to-date selection -- Getting ready -- How to do it... -- How it works... -- Using alternate states with Set Analysis -- Getting ready -- How to do it... -- How it works... -- There's more... -- See Also -- Using Set operators to exclude values from results -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using Set Analysis with a Date Island -- Getting ready -- How to do it... -- How it works... -- There's more... -- See Also -- Using Sets to avoid key tables
  • Getting ready -- How to do it... -- How it works... -- There's more... -- 4. Advanced Aggregations -- Introduction -- Using TOTAL to calculate the percentage of total and subtotal -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using AGGR to calculate the percentage of the maximum value -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using AGGR to resolve a "Sum of Rows" issue -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion -- Getting ready -- How to do it... -- How it works... -- See also -- Using RangeMax to return only positive numbers -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a dynamic Part-to-Whole pie chart -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a colored treemap using colormix -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using RangeSum to calculate a rolling total in a multidimension table -- Getting ready -- How to do it... -- How it works... -- There's more... -- Showing only the top 3 values in a pivot table -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a Statistical Control Chart using Standard Deviation -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a Moving Range chart -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Creating a control chart using Moving Range -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- 5. Advanced Coding -- Introduction -- Extracting QlikView data to a Word report -- Getting ready -- How to do it… -- How it works
  • There's more… -- See also -- Printing reports to PDF using PDFCreator -- Getting ready -- How to do it… -- How it works… -- See also -- Creating a chart using a macro -- Getting ready -- How to do it… -- How it works… -- There's more… -- Using VBS functions in charts -- Getting ready -- How to do it… -- How it works… -- There's more… -- 6. Data Modeling -- Introduction -- Concatenation of fact tables to avoid loops and synthetic keys -- Getting ready -- How to do it… -- How it works... -- There's more... -- See also -- Creating a Key/Link table in QlikView -- Getting ready -- How to do it… -- How it works... -- There's more... -- See also -- 7. Extensions -- Introduction -- Creating a simple HTML extension -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating a simple HTML table -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating an interactive extension -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Using external libraries with extensions -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- 8. Useful Functions -- Introduction -- Handling null in numeric fields or calculations -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Using Dual to handle period name sorting -- How to do it… -- How it works… -- There's more… -- See also -- Parsing text to numbers and dates -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Calculating Year To Date dynamically -- Getting ready -- How to do it… -- How it works… -- There's more… -- Labeling a pie chart to replace the legend -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Calculating the lowest or highest value in a range -- Getting ready -- How to do it… -- How it works
  • Intro -- QlikView for Developers Cookbook -- Table of Contents -- QlikView for Developers Cookbook -- Credits -- Foreword -- 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. Charts -- Introduction -- Creating custom pop-up labels on a bar chart -- Getting ready -- How to do it… -- How it works… -- There's more… -- Creating a box plot chart for a simple data set -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Using the wizard to create a box plot chart -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating a "Stephen Few" bullet chart -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating a modified bullet chart in a straight table -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating a bar chart in a straight table -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating a Redmond Aged Debt Profile chart -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating a waterfall chart -- Getting ready -- How to do it… -- How it works… -- There's more… -- Replacing the legend in a line chart with labels on each line -- Getting ready -- How to do it… -- How it works… -- There's more… -- See also -- Creating a secondary dimension in a bar chart -- Getting ready -- How to do it… -- How it works… -- There's more… -- Creating a line chart with variable width lines
  • How to do it...
  • There's more… -- Consolidating a date-time value into quarter hourly segments -- Getting ready -- How to do it… -- How it works… -- There's more… -- Dynamically filtering by From/To dates -- Getting ready -- How to do it… -- How it works… -- There's more… -- 9. Script -- Introduction -- Creating flags in the script -- Getting ready -- How to do it... -- How it works... -- There's more... -- Replacing IsNull -- Getting ready -- How to do it... -- How it works... -- There's more... -- Storing and dropping using a subroutine -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Keeping a trace on things -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Using the AND mode in listboxes -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using Exists and Keep to limit the data load -- Getting ready -- How to do it... -- How it works... -- There's more... -- Setting the default display format -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Setting the default sort order -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Matching financial periods to dates -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also -- Handling partial reload in the script -- Getting ready -- How to do it... -- How it works... -- There's more... -- Using Peek and Previous to calculate against loaded records -- Getting ready -- How to do it... -- How it works... -- There's more... -- Creating a simple Gantt for a dashboard using Interval Match -- Getting ready -- How to do it... -- How it works... -- See also -- Reading users from Active Directory -- Getting ready -- How to do it... -- How it works... -- Getting a sub-URL using the Table wizard -- Getting ready