QlikView for Developers Cookbook
eBook - ePub

QlikView for Developers Cookbook

  1. 290 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

QlikView for Developers Cookbook

About this book

In Detail

QlikView has been around since 1993, but has only really taken off in recent years as a leader in the in-memory BI space and, more recently, in the data discovery area. QlikView features the ability to consolidate relevant data from multiple sources into a single application, as well as an associative data model to allow you to explore the data to a way your brain works, state-of-the-art visualizations, dashboard, analysis and reports, and mobile data access.

QlikView for Developers Cookbook builds on your initial training and experiences with QlikView to help you become a better developer. This book features plenty of hands-on examples of many challenging functions.

Assuming a basic understanding of QlikView development, this book provides a range of step-by-step exercises to teach you different subjects to help build your QlikView developer expertise.

From advanced charting and layout to set analysis; from advanced aggregations through to scripting, performance, and security, this book will cover all the areas that you need to know about.

The recipes in this book will give you a lot of the information that you need to become an excellent QlikView developer.

Approach

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.

Who this book is for

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.

Trusted byĀ 375,005 students

Access to over 1 million titles for a fair monthly price.

Study more efficiently using our study tools.

Information

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

Table of contents

  1. QlikView for Developers Cookbook

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access QlikView for Developers Cookbook by Stephen Redmond in PDF and/or ePUB format, as well as other popular books in Computer Science & Business Intelligence. We have over one million books available in our catalogue for you to explore.