QlikView for developers cookbook : discover the strategies needed to tackle the most challenging tasks facing the QlikView developer /: discover the strategies needed to tackle the most challenging tasks facing the QlikView developer. (2013)
- Record Type:
- Book
- Title:
- QlikView for developers cookbook : discover the strategies needed to tackle the most challenging tasks facing the QlikView developer /: discover the strategies needed to tackle the most challenging tasks facing the QlikView developer. (2013)
- Main Title:
- QlikView for developers cookbook : discover the strategies needed to tackle the most challenging tasks facing the QlikView developer
- Further Information:
- Note: Stephen Redmond ; [foreword by Barry Harmsen].
- Other Names:
- Redmond, Stephen
- 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;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. … (more)
- Publisher Details:
- Birmingham : Packt Pub
- Publication Date:
- 2013
- Extent:
- 1 online resource (iv, 272 pages :), illustrations (chiefly color)
- Subjects:
- 658.472
COMPUTERS -- Enterprise Applications -- Business Intelligence Tools
BUSINESS & ECONOMICS -- Industrial Management
BUSINESS & ECONOMICS -- Management
BUSINESS & ECONOMICS -- Management Science
BUSINESS & ECONOMICS -- Organizational Behavior
Application software -- Development
Business intelligence
Application software / Development
Business intelligence
COMPUTERS -- Data Processing
Application software -- Development
Business intelligence
Application software -- Development
Business intelligence
Electronic books - Languages:
- English
- ISBNs:
- 9781782179740
1782179747
1782179739
9781782179733 - Related ISBNs:
- 9781782179733
- Access Rights:
- 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).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.87305
- Ingest File:
- 03_000.xml