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
Conferences
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 a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
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 : 9781849686068
Vendor :
Qlik
Category :
Tools :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Nov 20, 2012
Length: 534 pages
Edition : 1st
Language : English
ISBN-13 : 9781849686068
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

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.