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
• 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; 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.
• 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.