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
QlikView 11 for Developers
QlikView 11 for Developers

QlikView 11 for Developers: This book is smartly built around a practical case study – HighCloud Airlines – to help you gain an in-depth understanding of how to build applications for Business Intelligence using QlikView. A superb hands-on guide.

eBook
€8.99 €39.99
Paperback
€48.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents Preview book icon Preview Book

QlikView 11 for Developers

Chapter 2. Seeing is Believing

As we've seen in the previous chapter, HighCloud Airlines has a particular need: to be able to analyze the US airline market from different perspectives, be able to create reports that help them better understand what the situation is, and evaluate if entering that market is a good strategy. Sara took the risk and showed the CEO what they could potentially do with QlikView and he was impressed by what he saw. After their meeting, Sara was asked to arrange a formal proof-of-concept session.

This chapter will not only follow a QlikView team working on the Seeing is Believing (SiB) phase of the pre-sale process, along with the HighCloud Airlines executives evaluating it, but it will also help us learn some basic concepts about developing QlikView documents.

So, let's get our hands on the subject and start creating. There is no better way to learn than by doing, and this chapter will be the initial platform on which we will base our QlikView development experience...

What is a SiB?


A SiB (an acronym for Seeing is Believing) is the proof-of-concept session in which, during the pre-sale process, the technical capabilities of the QlikView software are demonstrated to the prospective customer. The way we demo QlikView at this stage usually involves creating a targeted QlikView document that uses the customer's actual data in a limited amount of time.

That's why, in this chapter, we will build a QlikView document based on real and useful data, focused on HighCloud Airlines' line of business. The dataset we will use is publicly available and covers information about airline operations in the US. The original data files have been downloaded from The Bureau of Transportation Statistics of the United States website (http://transtats.bts.gov), and have been pre-processed so that we can focus on the main concepts this chapter is intended to outline. As the book evolves, we will introduce more advanced concepts so that, in the end, we are able to work with the original...

Preparing the workspace


Before we start, we need to make sure we have everything we'll need throughout the chapter.

Since the previous chapter covered the QlikView Desktop installation process, we assume that it is already installed on your machine by now. If not, please take a moment to install it before continuing.

Setting up the folder structure

We will create a Windows folder structure with which we'll work throughout the book. This set of folders will help us organize the various files we'll be using and arrange them by the specific role these files play in our project.

Note

The files provided along with the book are already structured with the folders we need. If you have already copied the original files, you can skip the outlined process.

A typical QlikView deployment scenario will include different types of files, but for now we'll just focus on two of them:

  • The source data files

  • The QlikView document

Tip

Downloading the example code

You can download the example code files for all Packt...

Creating the app


We can think of a QlikView document as being composed of two major elements:

  • The dataset that the user analyzes: This is the backend of our QlikView document and includes all of the source tables needed to build a data model, as well as the logic to update its source data.

  • The user interface through which the user analyzes the data: This is the frontend of our analytical app and includes the objects contained in he document (like a listbox to make selections and filter data), or the charts and tables used to visualize the information.

In hand with the elements described above, we will break the construction of our QlikView document into two major phases:

  • Constructing the data model

  • Designing the user interface

However, before moving on to create our QlikView document, we should have a clear understanding of the business-side requirements for our app, so the construction and design phases are fully focused towards meeting those requirements.

The requirements

In our SiB scenario...

Summary


We have just started creating and building analytical applications with QlikView. Although the data model we used was simple to build, we covered the basic concepts a developer should consider when designing it.

The main objective of this chapter was to show you the basics of QlikView development from the design perspective, to create basic objects, and to change different properties to make them more functional.

This chapter helped you learn how to load source tables from QVDs, to associate different source tables to create a data model, and to identify dimensions and expressions in the context of a QlikView document.

It also showed you how to create a user interface with user controls to filter data and make selections. Finally, we learned how to create charts and tables that have a high degree of interactivity.

In the next chapter we will learn how we can load data from different data sources.

Left arrow icon Right arrow icon

Key benefits

  • Learn to build applications for Business Intelligence while following a practical case -- HighCloud Airlines. Each chapter develops parts of the application and it evolves throughout the book along with your own QlikView skills.
  • The code bundle for each chapter can be accessed on your local machine without having to purchase a QlikView license.
  • The hands-on approach allows you to build a QlikView application that integrates real data from several different sources and presents it in dashboards, analyses and reports.

Description

Business Intelligence technologies are a must-have in every business to make informed decisions and keep up-to speed with the ever-evolving markets. QlikView's disruptive technology makes it a key player and leader in the industry; with its flexibility and powerful analytics environment, building QlikView apps can be mastered by both, business users as well as developers. This book will help you learn QlikView Development from a basic to a practitioner level using a step-by-step approach in a practical environment, and apply proven best practices on each topic. Throughout the book, we will build a QlikView app based on real data about Airline Operations that will help "HighCloud Airlines" make informed business decisions and analysis-guided strategies. HighCloud Airlines executives are evaluating if entering the US market is a good strategy and, if so, which line of business should they focus their investments on; they need QlikView to make the best decision. The application will be evolving chapter by chapter, along with your skills, going from a simple proof of concept to creating a Data Model, adding a custom style, building a Dashboard and handling and manipulating the source data via script. We will meet the "HighCloud Airlines" requirement by using many different data visualization objects and time-saving techniques. The whole application uses real data taken from the Bureau of Transportations statistics of the US and encompasses the operations of Airlines both domestic and international. With three years worth of data, you will help HighCloud Airlines discover where people travel the most, which are the Carriers with the most market share, what is the average load factor per airline, which aircraft is the most used to perform flights, which are the busiest airports, and a whole universe of new insights.

Who is this book for?

If you are a developer who is looking to learn a fast and easy way to learn to develop your business intelligence apps with QlikView, then this book is for you. If you are a power-user in a QlikView environment, then you will find quicker ways of working with QlikView. You should know the basics of business intelligence before you pick up this book. This book covers QlikView Desktop Personal Edition. Deployments to QlikView Server/Publisher are out of scope for this book.

What you will learn

  • Learn the techniques and best practices to transform data in QlikView via script
  • Loading data from disparate sources to build an associative Data Model
  • Building robust data models and overcoming common modeling challenges
  • Designing data visualization objects to present performance measures with charts and tables
  • Learn to use dimensions and expressions in QlikView objects
  • Utilise QlikView s built-in aggregation functions to achieve complex calculations
  • Creating Point In Time reporting and achieving complex calculations using Set Analysis
  • Creating a consistent and interactive user interface
  • Ensuring your QlikView applications and data are protected
  • Constructing a data architecture that supports scalable QlikView deployments
  • Learn time-saving techniques for making your QlikView development more efficient

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Nov 20, 2012
Length: 534 pages
Edition : 1st
Language : English
ISBN-13 : 9781849686075
Vendor :
Qlik
Category :
Tools :

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Nov 20, 2012
Length: 534 pages
Edition : 1st
Language : English
ISBN-13 : 9781849686075
Vendor :
Qlik
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 86.98
QlikView for Developers Cookbook
€37.99
QlikView 11 for Developers
€48.99
Total 86.98 Stars icon
Banner background image

Table of Contents

14 Chapters
Meet QlikView Chevron down icon Chevron up icon
Seeing is Believing Chevron down icon Chevron up icon
Data Sources Chevron down icon Chevron up icon
Data Modeling Chevron down icon Chevron up icon
Styling Up Chevron down icon Chevron up icon
Building Dashboards Chevron down icon Chevron up icon
Scripting Chevron down icon Chevron up icon
Data Modeling Best Practices Chevron down icon Chevron up icon
Basic Data Transformation Chevron down icon Chevron up icon
Advanced Expressions Chevron down icon Chevron up icon
Set Analysis and Point In Time Reporting Chevron down icon Chevron up icon
Advanced Data Transformation Chevron down icon Chevron up icon
More on Visual Design and User Experience Chevron down icon Chevron up icon
Security Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.5
(46 Ratings)
5 star 71.7%
4 star 17.4%
3 star 4.3%
2 star 2.2%
1 star 4.3%
Filter icon Filter
Top Reviews

Filter reviews by




Amazon Customer Jan 18, 2014
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Valueable reading also for fairly advanced users. Best practice for QlikView but also valuable intro to general BI and DW concepts.
Amazon Verified review Amazon
Johan L. Brattås Feb 18, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book is one of the better tool specific BI books I've read. I started off with Qlikview in January after working with MIcrosoft SQL stack for a while. The book is well written, well paced and well edited. The sample case the book takes you through is pedagogical, and with enough sample data to give you a real feeling of how Qlikview handles.I'd recommend this book to anyone looking for study material for their certification (it definately helped me pass my exam) as well as for entry level Qlikview developers. I dare say intermediate level developers as well due to the authors' best practice guides - but I'm to new with Qlikview to put money on it...
Amazon Verified review Amazon
Carlos Rodriguez Feb 22, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great book really useful to learn Qlikview
Amazon Verified review Amazon
Cem YääŸman Jun 25, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Getting over qlikview starting from basic functions to more complex ones.Lots of online source links inside.Usefull best practises.Downloadable pdf book
Amazon Verified review Amazon
Choubi Feb 20, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This is an excellent book, good for techies and managers with great worked examples.If you want to learn Qlikview then buy this book.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.