Packt+ | Advance your knowledge in tech

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

QlikView for Developers

You're reading from QlikView for Developers Design and build scalable and maintainable BI solutions

Product type Paperback

Published in Jun 2017

Publisher Packt

ISBN-13 9781786469847

Length 546 pages

Edition 1st Edition

Tools

QlikView

Concepts

Data Visualization

Authors (2):

Miguel Angel Garcia

Barry Harmsen

View More author details

Table of Contents (17) Chapters

Preface

1. Meet QlikView FREE CHAPTER

2. What's New in QlikView 12?

3. Seeing is Believing

4. Data Sources

5. Data Modeling

6. Styling Up

7. Building Dashboards

8. Scripting

9. Data Modeling Best Practices

10. Basic Data Transformation

11. Advanced Expressions

12. Set Analysis and Point In Time Reporting

13. Advanced Data Transformation

14. More on Visual Design and User Experience

15. Security

Index

Merging forces

On their own, the Order By statement and the Peek function are already powerful. Now, imagine what happens when we combine both of these tools to enhance our input data. In this section, we will use both of these functions to add a new calculated field to our Employment table (the one we integrated to our data model in Chapter 9, Data Modeling Best Practices).

A refresher

The Employment table provides information regarding the monthly number of employees per airline. The total number is split between part and full time employees, and it also shows the total FTEs (Full Time Equivalent).

The objective

The executives of HighCloud Airlines have asked the QlikView team to create a report that shows the monthly change in number of employees in a line chart to discover and analyze peaks in the employment behavior of each airline.

Getting it done

First, how do we find the total change in number of employees for this month compared to the last? Well, we take the number of employees in the...

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

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (2)

Miguel Angel Garcia

Miguel Angel Garcia

Miguel Ángel García is a Business Intelligence consultant and Qlik Solutions Architect from Monterrey, Mexico. Having worked throughout many successful Qlik implementations, from inception through implementation, and performed across a wide variety of roles on each project, his experience and skills range from pre-sales to applications development and design, technical architecture, system administration, as well as functional analysis and overall project execution. He currently holds the QlikView Designer, QlikView Developer, and QlikView System Administrator Certifications.

See other products by Miguel Angel Garcia

Barry Harmsen

Barry Harmsen

Barry Harmsen is a Business Intelligence Consultant based in the Netherlands. Here he runs Bitmetric, a boutique consulting firm specialized in the Qlik product suite. Originally from a background of traditional business intelligence, data warehousing, and performance management, in 2008 Barry made the shift to Qlik and a more user-centric form of Business Intelligence. Since then, he and his team have helped many clients get the most out of their investments in the Qlik platform. Barry is one of the four Qlik experts teaching at the Masters Summit for Qlik, an advanced 3-day training for experienced Qlik professionals. He also runs the Amsterdam chapter of the Qlik Dev Group, an open and informal gathering where Qlik professionals can share knowledge and experiences.

See other products by Barry Harmsen

Other recommended products

Related to this chapter

Hands-On Dashboard Development with QlikView

Hands-On Dashboard Development with QlikView

The book will help you build effective business intelligence dashboards using the latest features of QlikView. You will create different types of visualizations such as bar charts, interactive plots, and more. With this book, you will learn how to gain actionable insights from your data and communicate them across to relevant stakeholders in the best possible manner.

Mar 2019 5h 12m

Hands-On Dashboard Development with QlikView

Hands-On Dashboard Development with QlikView

The book will help you build effective business intelligence dashboards using the latest features of QlikView. You will create different types of visualizations such as bar charts, interactive plots, and more. With this book, you will learn how to gain actionable insights from your data and communicate them across to relevant stakeholders in the best possible manner.

Mar 2019 5h 12m

Qlik Sense Cookbook

Qlik Sense Cookbook

An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. This book is for people who are looking to create fully featured desktop applications to gain additional business insights in the workplace. It also includes features added recently to Qlik Sense such as Aggr and Data stories.

Aug 2018 11h 8m

Qlik Sense Cookbook

Qlik Sense Cookbook

An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. This book is for people who are looking to create fully featured desktop applications to gain additional business insights in the workplace. It also includes features added recently to Qlik Sense such as Aggr and Data stories.

Aug 2018 11h 8m

Qlik Sense Cookbook

Qlik Sense Cookbook

An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. This book is for people who are looking to create fully featured desktop applications to gain additional business insights in the workplace. It also includes features added recently to Qlik Sense such as Aggr and Data stories.

Aug 2018 11h 8m

Qlik Sense Cookbook

Qlik Sense Cookbook

An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. This book is for people who are looking to create fully featured desktop applications to gain additional business insights in the workplace. It also includes features added recently to Qlik Sense such as Aggr and Data stories.

Aug 2018 11h 8m

Qlik Sense Cookbook

Qlik Sense Cookbook

An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. This book is for people who are looking to create fully featured desktop applications to gain additional business insights in the workplace. It also includes features added recently to Qlik Sense such as Aggr and Data stories.

Aug 2018 11h 8m

Qlik Sense Cookbook

Qlik Sense Cookbook

An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. This book is for people who are looking to create fully featured desktop applications to gain additional business insights in the workplace. It also includes features added recently to Qlik Sense such as Aggr and Data stories.

Aug 2018 11h 8m

Hands-On Business Intelligence with Qlik Sense

Hands-On Business Intelligence with Qlik Sense

This book is an excellent entry-level guide for all aspiring Qlik Sense developers to create applications in Qlik Sense Desktop to obtain daily insights at work. You'll be able to implement what you've learned to overcome in day-to-day stumbling blocks faced in the BI domain.

Feb 2019 14h 44m

Hands-On Business Intelligence with Qlik Sense

Hands-On Business Intelligence with Qlik Sense

This book is an excellent entry-level guide for all aspiring Qlik Sense developers to create applications in Qlik Sense Desktop to obtain daily insights at work. You'll be able to implement what you've learned to overcome in day-to-day stumbling blocks faced in the BI domain.

Feb 2019 14h 44m

Hands-On Business Intelligence with Qlik Sense

Hands-On Business Intelligence with Qlik Sense

This book is an excellent entry-level guide for all aspiring Qlik Sense developers to create applications in Qlik Sense Desktop to obtain daily insights at work. You'll be able to implement what you've learned to overcome in day-to-day stumbling blocks faced in the BI domain.

Feb 2019 14h 44m

Hands-On Business Intelligence with Qlik Sense

Hands-On Business Intelligence with Qlik Sense

This book is an excellent entry-level guide for all aspiring Qlik Sense developers to create applications in Qlik Sense Desktop to obtain daily insights at work. You'll be able to implement what you've learned to overcome in day-to-day stumbling blocks faced in the BI domain.

Feb 2019 14h 44m

Personalised recommendations for you

Based on your interests and search pattern

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m