Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
QlikView for Developers Cookbook

You're reading from   QlikView for Developers Cookbook Take your QlikView training to the next level with this brilliant book that's packed with recipes which progress from intermediate to advanced. The step-by step-approach makes learning easy and enjoyable.

Arrow left icon
Product type Paperback
Published in Jun 2013
Publisher Packt
ISBN-13 9781782179733
Length 290 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Stephen Redmond Stephen Redmond
Author Profile Icon Stephen Redmond
Stephen Redmond
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

QlikView for Developers Cookbook
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Charts FREE CHAPTER 2. Layout 3. Set Analysis 4. Advanced Aggregations 5. Advanced Coding 6. Data Modeling 7. Extensions 8. Useful Functions 9. Script 10. Improving Performance 11. Security Index

Preface

There is no substitute for experience.

QlikView is a great technology for delivering information and, unusually for a "BI" product, is quite easy to get up and running with simple data sets – they even have a wizard that can get you up and running off an Excel file without having to do any scripting. If you need to bring in more complex data sets, you need to get into the script. Even then, there are some wizards available that will write most of the script for you.

To start your learning process, there are free resources available from http://www.qlikview.com/training. There is a very active community forum on http://community.qlikview.com, where you can ask questions and get answers. There is a really excellent book that teaches you how to develop in QlikView, QlikView 11 for Developers by Barry Harmsen and Mike García (http://www.packtpub.com/qlikview-11-developers/book). Then, if you still need it after all that, you can attend official QlikView classroom training. But, there is no substitute for experience.

At CapricornVentis, we don't just train and leave. We schedule time with the trainees to sit with them, one-on-one, and work on their data, to give them the benefit of our experience, to answer all of those, "How do I do that" questions. We do this because we understand that training isn't enough. It is a great start, but there is no substitute for experience.

And this, I hope, is what this book is—the benefit of my experience.

I have been working with QlikView since 2006. As well as working at the coalface, delivering great solutions, I have also been delivering QlikView training for most of that time. I was one of the first two people in the world (neither of us is sure who was first!) to be certified when QlikView brought out their first developer certification on Version 8. I was one of the earliest certified on designer for Version 8. I have since been recertified on every version up to the latest certifications on Version 11. I have been writing about QlikView on my blog, http://qliktips.blogspot.com, since 2009. I have quite a lot of experience with QlikView. And there is no substitute for experience.

What this book covers

Chapter 1, Charts, will look at advanced charting topics such as creating custom pop ups, box charts, bullet charts, and the Redmond chart. We also look at some tips and tricks to create great visualizations.

Chapter 2, Layout, will look at how to modify some of the default layout options and colors, as well as discussing better ways to layout objects.

Chapter 3, Set Analysis, shows some advanced examples of using set analysis in different scenarios.

Chapter 4, Advanced Aggregations, looks at parameters such as TOTAL and functions such as AGGR and the Range functions that allow us to perform vertical calculations.

Chapter 5, Advanced Coding, uses VBScript coding to extract data from QlikView, generate reports, create QlikView objects, and enhance QlikView functionality.

Chapter 6, Data Modeling, covers the area of key tables and link tables, an area that can be confused with new QlikView developers.

Chapter 7, Extensions, introduces the ability to create new visualizations with web technologies and integrate them into QlikView documents.

Chapter 8, Useful Functions, gives you examples of using some of QlikView's very useful functions in different scenarios.

Chapter 9, Script, takes your QlikView scripting a step beyond training. Includes discussion on creating flags, exists and keep, default formats, partial loads, peek and previous, and interval match.

Chapter 10, Improving Performance, shows how to improve the performance of a QlikView data model. Discusses strategies such as reducing data sizes and optimizing expressions. Also, when and when not to denormalize for performance.

Chapter 11, Security, goes through some of the most common issues around section access security in QlikView.

What you need for this book

You need a copy of QlikView Desktop, which you can download for free from http://www.qlikview.com/download. After that, you shouldn't need anything else.

To demonstrate the different techniques and functions, I will usually get you to load a table of data. We do this using the INLINE function. For example:

Load * Inline [
  Field1, Field2
  Value1, Value2
  Value3, Value4
];

This will load a table with two fields (Field1 and Field2) and two rows of data.

Most of the time, this type of table is enough for what we need to do. In the few examples, where I need you to use more data than that, we will use publicly available data sources.

Who this book is for

This book is for anyone who has loaded data in QlikView, created a few charts, and then asked the question, "How do I?" If you have either attended QlikView Developer training or have taught yourself QlikView from books or online sources, this book is meant for you. You might be working for a QlikView customer, partner, or even QlikView themselves (or want to) and want to improve your QlikView skills.

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "We do this using the INLINE function."

A block of code is set as follows:

Sales:
Load * INLINE [
  Country, Sales
  USA, 1000
  UK, 940
  Japan, 543
];

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

Sales:
Load * INLINE [
  Country, Sales
  USA, 1000
  UK, 940
  Japan, 543
];

Any command-line input or output is written as follows:

C:\Program Files\QlikView\qv.exe

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Click on the Extension Objects menu."

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to , and mention the book title via the subject of your message.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Downloading the example code

You can download the example code files for all Packt books you have purchased from your account at http://www.packtpub.com. If you purchased this book elsewhere, you can visit http://www.packtpub.com/support and register to have the files e-mailed directly to you.

Errata

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.

Piracy

Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.

Questions

You can contact us at if you are having a problem with any aspect of the book, and we will do our best to address it.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime
Banner background image