LEADER 00000cam a2200721Ma 4500 001 ocn854569124 003 OCoLC 005 20210122120300.2 006 m o d 007 cr cn||||||||| 008 130715s2013 enkad o 001 0 eng d 015 GBB747200|2bnb 016 7 018006399|2Uk 019 852756686|a857497444|a961666596|a962573978|a971596350 |a971950990|a974766521|a974861975|a981863138|a989273896 |a993655946|a1005641072|a1018057406|a1041922713 |a1053513709|a1058138067|a1065707845|a1081230414 |a1083556025|a1103271741|a1118378967|a1129355365 020 9781782179740|q(e-book) 020 1782179747|q(e-book) 020 1782179739 020 9781782179733 020 |z9781782179733 035 (OCoLC)854569124|z(OCoLC)852756686|z(OCoLC)857497444 |z(OCoLC)961666596|z(OCoLC)962573978|z(OCoLC)971596350 |z(OCoLC)971950990|z(OCoLC)974766521|z(OCoLC)974861975 |z(OCoLC)981863138|z(OCoLC)989273896|z(OCoLC)993655946 |z(OCoLC)1005641072|z(OCoLC)1018057406|z(OCoLC)1041922713 |z(OCoLC)1053513709|z(OCoLC)1058138067|z(OCoLC)1065707845 |z(OCoLC)1081230414|z(OCoLC)1083556025|z(OCoLC)1103271741 |z(OCoLC)1118378967|z(OCoLC)1129355365 037 CL0500000272|bSafari Books Online 040 E7B|beng|epn|cE7B|dOCLCQ|dOCLCO|dOCLCF|dCOO|dEBLCP|dIDEBK |dMEAUC|dUMI|dDEBSZ|dN$T|dYDXCP|dOCLCQ|dAGLDB|dMOR|dPIFAG |dZCU|dMERUC|dOCLCQ|dU3W|dSTF|dWRM|dOCLCQ|dNRAMU|dICG|dNLE |dINT|dVT2|dAU@|dOCLCQ|dUKMGB|dOCLCQ|dA6Q|dDKC|dOCLCQ |dUKAHL|dNLW|dOCLCQ 049 RIDW 050 4 QA76.76.A65|bR43 2013eb 072 7 BUS|x082000|2bisacsh 072 7 BUS|x041000|2bisacsh 072 7 BUS|x042000|2bisacsh 072 7 BUS|x085000|2bisacsh 082 04 658.472 090 QA76.76.A65|bR43 2013eb 100 1 Redmond, Stephen|c(Information technologist)|0https:// id.loc.gov/authorities/names/no2020027763 245 10 QlikView for developers cookbook :|bdiscover the strategies needed to tackle the most challenging tasks facing the QlikView developer /|cStephen Redmond ; [foreword by Barry Harmsen]. 264 1 Birmingham :|bPackt Pub.,|c2013. 300 1 online resource (iv, 272 pages) :|billustrations (chiefly color) 336 text|btxt|2rdacontent 337 computer|bc|2rdamedia 338 online resource|bcr|2rdacarrier 340 |gpolychrome|2rdacc 347 text file|2rdaft 500 "Quick answers to common problems"--Cover. 500 Includes index. 505 0 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. 505 8 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. 505 8 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. 505 8 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. 505 8 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. 506 1 Legal Deposit;|cOnly available on premises controlled by the deposit library and to one user at any one time;|eThe Legal Deposit Libraries (Non-Print Works) Regulations (UK).|5WlAbNL 520 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. 540 Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.|5WlAbNL 590 eBooks on EBSCOhost|bEBSCO eBook Subscription Academic Collection - North America 650 0 Application software|xDevelopment.|0https://id.loc.gov/ authorities/subjects/sh95009362 650 0 Business intelligence.|0https://id.loc.gov/authorities/ subjects/sh85018300 650 7 Application software|xDevelopment.|2fast|0https:// id.worldcat.org/fast/811707 650 7 Business intelligence.|2fast|0https://id.worldcat.org/fast /842723 655 4 Electronic books. 776 08 |iPrint version:|aRedmond, Stephen.|tQlikView for Developers Cookbook.|dBirmingham : Packt Publishing, ©2013 |z9781782179733 856 40 |uhttps://rider.idm.oclc.org/login?url=http:// search.ebscohost.com/login.aspx?direct=true&scope=site& db=nlebk&AN=601394|zOnline ebook via EBSCO. Access restricted to current Rider University students, faculty, and staff. 856 42 |3Instructions for reading/downloading the EBSCO version of this ebook|uhttp://guides.rider.edu/ebooks/ebsco 901 MARCIVE 20231220 948 |d20210519|cEBSCO|tEBSCOebooksAcademic 1-22-21 4032|lridw 994 92|bRID