Book Image

Mastering Qlik Sense

By : Juan Ignacio Vitantonio
Book Image

Mastering Qlik Sense

By: Juan Ignacio Vitantonio

Overview of this book

Qlik Sense is a powerful, self-servicing Business Intelligence tool for data discovery, analytics and visualization. It allows you to create personalized Business Intelligence solutions from raw data and get actionable insights from it. This book is your one-stop guide to mastering Qlik Sense, catering to all your organizational BI needs. You'll see how you can seamlessly navigate through tons of data from multiple sources and take advantage of the various APIs available in Qlik and its components for guided analytics. You'll also learn how to embed visualizations into your existing BI solutions and extend the capabilities of Qlik Sense to create new visualizations and dashboards that work across all platforms. We also cover other advanced concepts such as porting your Qlik View applications to Qlik Sense,and working with Qlik Cloud. Finally, you'll implement enterprise-wide security and access control for resources and data sources through practical examples. With the knowledge gained from this book, you'll have become the go-to expert in your organization when it comes to designing BI solutions using Qlik Sense.

Related Content you might be interested in

Current Title:

Small book image
Mastering Qlik Sense
Juan Ignacio Vitantonio
Mar, 2018 | 514 pages
Small book image
Hands-On Business Intelligence with Qlik Sense
Pablo Labbe | Kaushik Solanki | Jerry DiMaso | CLEVER MARCIO ANJOS
Feb, 2019 | 442 pages
Small book image
Qlik Sense Cookbook
Pablo Labbe | Neeraj Kharpate | Philip Hand
Aug, 2018 | 334 pages
Small book image
QlikView for Developers
Barry Harmsen | Miguel Angel Garcia
Jun, 2017 | 546 pages
Table of Contents (16 chapters)
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
Free Chapter
1
Qlik Sense Self-Service Model
Qlik Sense Self-Service Model
A review of Qlik Sense
The Self-Service model
The IKEA effect
User types in self-service
Benefits and challenges of self-service
Recommendations on deploying self-service with Qlik Sense
Summary
2
Transitioning from QlikView to Qlik Sense
Transitioning from QlikView to Qlik Sense
Journey from QlikView to Qlik Sense
QlikView and Qlik Sense comparison
The different approach to projects
Differences in the loading script
Differences in the frontend
Where to upskill to transition to Qlik Sense
Qlik Sense on mobile
Summary
3
Security Rules: Attribute Based Access Control
Security Rules: Attribute Based Access Control
Introducing Attribute-Based Access Control
Administrator roles
Security rules resources
Security rules actions
Security rules conditions
Auditing security rules
Security rule uses cases and examples
Summary
4
Master Items in Qlik Sense
Master Items in Qlik Sense
Understanding Master Items
Different types of Master Items
Working with Master Items
Master measures
Master visualizations
Summary
5
Qlik Sense on the Cloud
Qlik Sense on the Cloud
Data analytics in the cloud
Qlik Sense cloud models
Hybrid cloud
Summary
6
Qlik Sense Data Modeling
Qlik Sense Data Modeling
The engine drives everything
What should be done upstream from Qlik Sense?
Star schema fact and dimension tables
Summary
7
Best Practices for Loading Data in Qlik Sense
Best Practices for Loading Data in Qlik Sense
Data loading concepts
Optimizing your data loads
Incremental loads
ETL – extract, transform, load
Summary
8
Advanced Scripting
Advanced Scripting
Formatting settings through variables
Script control statements
Table stats
Data security with Section Access
Advanced sample scripts
Summary
9
Advanced Expressions in Qlik Sense
Advanced Expressions in Qlik Sense
Set analysis
Variables
Maintaining expressions
Summary
10
Overview of Qlik Sense APIs
Overview of Qlik Sense APIs
What is an API?
Description of Qlik APIs
Engine API
Extension API
Backend API
Capability API
enigma.js
Leonardo UI
halyard.js
Summary
11
Working with the Qlik Dev Hub
Working with the Qlik Dev Hub
Dev Hub
The Single configurator
The Extension editor
The Mashup editor
The Widget editor
QlikView converter
Summary
12
Coding in Qlik Sense
Coding in Qlik Sense
HTML5
CSS
JavaScript
RequireJS
AngularJS
D3.js as a visualization library
Summary
13
Creating Extensions in Qlik Sense
Creating Extensions in Qlik Sense
Structuring your code
The properties panel
HyperCube
Example 1-bar chart
Example 2- drop-down list
Qlik Branch and other open source repositories
Summary
14
Integrating QS in Websites via Mashups
Integrating QS in Websites via Mashups
Getting set up
Connecting to the Qlik Engine
Embedding objects
Interacting with the Engine
Summary
15
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think

QlikView converter

The QlikView converter, as its names suggests, converts QlikView application applications into Qlik Sense applications.

This very simple to use tool allows you to automatically convert most objects and scripts in a .qvw file into the Qlik Sense format. As not every object or syntax in QlikView is supported in Qlik Sense, there will be things that you will not be able to automatically convert. Using the converter is usually better than creating your application from scratch. Personally, I have used QlikView converter in several projects, and was impressed by how easy to use and straightforward it is.

To show how the converter works, I am going to use the Movies Database.qvw file that comes with any QlikView installation. The steps to convert your QlikView application into a Qlik Sense one are:

From within Dev Hub:

  1. Click on QlikView converter.
  2. Locate the .qvw...
Previous Section
End of Section 7
Next Section