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

Changing the source table structure

We've seen how the QlikView engine works and the importance of having a data model design that fully takes advantage of QlikView's associative algorithms. So, the first section of this chapter deals with transforming source tables to make them adequate for our data model. The different structure transformations we'll make are:

"Cleansing" a dirty table
Converting a Crosstable to a standard table
Using hierarchy tables
Loading generic tables

"Cleansing" a dirty table

As we've said before, it's not that uncommon for business users to require consolidated information from all sorts of different sources: the CRM, the company's Data Warehouse, Excel tables, Legacy systems, and so on. In these scenarios, the developer commonly faces the challenge of adapting a user file (Excel, CSV, TXT) that has either a non-standard structure or contains "dirty" data which needs to be removed, such as report headers or...

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