Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Qlik Sense Cookbook
Qlik Sense Cookbook

Qlik Sense Cookbook: Over 80 recipes on data analytics to solve business intelligence challenges , Second Edition

Arrow left icon
Profile Icon Labbe Profile Icon Hand Profile Icon Kharpate
Arrow right icon
zł39.99 zł158.99
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.3 (6 Ratings)
eBook Aug 2018 334 pages 2nd Edition
eBook
zł39.99 zł158.99
Paperback
zł197.99
Subscription
Free Trial
Arrow left icon
Profile Icon Labbe Profile Icon Hand Profile Icon Kharpate
Arrow right icon
zł39.99 zł158.99
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.3 (6 Ratings)
eBook Aug 2018 334 pages 2nd Edition
eBook
zł39.99 zł158.99
Paperback
zł197.99
Subscription
Free Trial
eBook
zł39.99 zł158.99
Paperback
zł197.99
Subscription
Free Trial

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

Qlik Sense Cookbook

Visualizations

In this chapter, we will cover some visualization tips and tricks to create a compelling dashboard in Qlik Sense:

  • Creating snapshots
  • Creating and adding content to a story
  • Adding embedded sheets to the story
  • Highlighting the performance measure in a bar chart
  • Associating persistent colors to field values using the script
  • Using the colormix1 function
  • Composition
  • Relationships
  • Comparison
  • Distribution
  • Structuring visualizations
  • Measuring statistical data with box plot charts
  • Using a waterfall chart to analyze the cumulative effect

Introduction

A typical Qlik Sense application should always follow the Dashboard Analysis Reporting (DAR) methodology. This methodology focuses on developing a dashboard sheet followed by an analysis sheet and then a reports sheet. The dashboard projects the high-level figures of the business; the analysis sheet gives more control to the end user to filter the data, while the reports sheet has the detailed information at a granular level.

While this concept can be easily implemented within the application, it is easy to forget the best design practices that help in making the applications more engaging for users. An optimal design will convey the right information to the right people at the right time. This will elevate the decision-making process within...

Creating snapshots

Snapshots are an exciting feature in Qlik Sense that enable users to capture the point-in-time state of the data object. Snapshots work as insights for a story, which will be discussed in later recipes.

Getting ready

For the sake of this exercise, we will make use of the Automotive.qvf Qlik Sense application. This application is downloaded as a sample file with the default Qlik Sense desktop installation and can be accessed through the Qlik Sense hub.

The sample files may differ by region. If the Automotive.qvf application is not available
in the Qlik Sense hub, it can be downloaded from the Packt Publishing website.

Perform the following steps once you download the application from the Packt Publishing...

Creating and adding content to a story

Qlik Sense introduces the concept of storytelling within the application. The data story interface helps the user to collate all the important observations and insights from the application to create a convincing narrative and present it to the intended audience in the form of a slideshow.

Getting ready

As in the previous recipe, we will again make use of the Automotive.qvf Qlik Sense application.

How to do it...

To create a story, perform the following steps:

  1. Open the Automotive.qvf application
  2. While you are still on the App overview...

Adding embedded sheets to the story

Multiple sheets can be added to the story and the following section deals with the steps involved.

Getting ready

As in the previous recipe, we will again make use of the Automotive.qvf Qlik Sense application:

  1. Open the Automotive.qvf application from the Qlik Sense hub.
  2. Next, open the Sales Overview story, which was created in the previous recipe, by clicking on the toolbar.

How to do it...

Please follow the steps for adding embedded sheets to the story:

  1. In the story view, click on the icon in the bottom-left corner of the storyboard...

Highlighting the performance measure in a bar chart

One of the essential components of a Qlik Sense dashboard is the Key Performance Indicators (KPIs). The KPIs indicate the health of the company based on specific measures. The information displayed in the KPI should stand out distinctly and demand attention. For example, one of the key KPIs that a CEO of the company may like to have on his dashboard is Actuals vs Budget. A CEO is mostly interested in knowing whether the company is below or above the budgeted figures. So, it makes sense to highlight the required information inside the visualization object. The following recipe explains and shows you how to do this in a bar chart.

Getting ready

A "Dial Gauge" is quite...

Associating persistent colors to field values using the script

The best practices say that a designer should avoid using bar charts with multi-colored bars or avoid having too many colors in any of your chart objects. But, at times, we need to cater to the demands of the organization and take an uncalled for approach to designing. The following recipe explains how to associate a distinct field value with different colors in the Qlik Sense script.

Getting ready

This recipe serves as a good example to demonstrate the use of the pick function in the script. Perform the following steps to get started:

  1. Create a new Qlik Sense application and name it Persistent Colors.
  2. Open the Data load editor.
  3. Load the following script that contains...

Using the colormix1 function

Heat maps are a common requirement in most of the BI implementations. A colormix1 function helps to create a gradient between two colors. Look at the following recipe to understand the use of this function.

Getting ready

We will make use of a simple inline load for this recipe. Perform the following steps to get started:

  1. Create a new Qlik Sense application. Name it HeatMaps_Colormix1.
  2. Open the Data load editor.
  3. Load the following script that gives you information about actuals and budget for products:
Products:
LOAD * INLINE [
Product, Actuals, Budget
Footwear, 100000, 120000
Tyres, 180000, 150000
Mountain Bikes, 250000, 195000
Road Bikes, 200000, 225000
Chains, 80000, 90000
Helmets, 240000,160001
Gloves...

Composition

Composition can be defined as looking at a particular measure compared to the whole.

For example, in a "Sales by Region" chart, the sales for each singular region would be a discrete value, while the total sales across all countries would be the "Whole".

Total sales can be divided into "Relative shares" for each region. Having information on "Relative Sales Percentages," as compared to total sales, has a greater impact rather than viewing just the plain sales figures. Eureka moments are much more likely when people use a tool to answer their own questions, which is a core belief behind the design of Qlik Sense.

As with everything else, data composition can be visualized in multiple ways. Understanding what you are trying to achieve will eventually dictate the best choice of visualization.

For example, depending on what matters...

Introduction


A typical Qlik Sense application should always follow the Dashboard Analysis Reporting (DAR) methodology. This methodology focuses on developing a dashboard sheet followed by an analysis sheet and then a reports sheet. The dashboard projects the high-level figures of the business; the analysis sheet gives more control to the end user to filter the data, while the reports sheet has the detailed information at a granular level.

Note

For more information on the DAR concept, visit https://community.qlik.com/blogs/qlikviewdesignblog/2013/11/08/dar-methodology.

While this concept can be easily implemented within the application, it is easy to forget the best design practices that help in making the applications more engaging for users. An optimal design will convey the right information to the right people at the right time. This will elevate the decision-making process within the organization.

This chapter focuses on some of the key concepts in data visualization that will help the users...

Creating snapshots


Snapshots are an exciting feature in Qlik Sense that enable users to capture the point-in-time state of the data object. Snapshots work as insights for a story, which will be discussed in later recipes.

Getting ready

For the sake of this exercise, we will make use of the Automotive.qvf Qlik Sense application. This application is downloaded as a sample file with the default Qlik Sense desktop installation and can be accessed through the Qlik Sense hub.

The sample files may differ by region. If the Automotive.qvf application is not available in the Qlik Sense hub, it can be downloaded from the Packt Publishing website.

Perform the following steps once you download the application from the Packt Publishing website (https://www.packtpub.com/big-data-and-business-intelligence/qlik-sense-cookbook-second-edition):

  1. Copy the .qvf file to the C:\Users\<user>\Documents\Qlik\Sense\Apps folder
  2. Open the Qlik Sense desktop and the app will appear in the hub

How to do it…

Qlik Sense provides...

Creating and adding content to a story


Qlik Sense introduces the concept of storytelling within the application. The data story interface helps the user to collate all the important observations and insights from the application to create a convincing narrative and present it to the intended audience in the form of a slideshow.

Getting ready

As in the previous recipe, we will again make use of the Automotive.qvf Qlik Sense application.

How to do it…

To create a story, perform the following steps:

  1. Open the Automotive.qvf application
  2. While you are still on the App overview page, click
    on the toolbar
  3. Click on the
    sign to create a new story
  4. Add the story name as Sales Overview and description as A narrative of the overall sales for the company
  5. Click outside the description window to save the story

To add content to a storyboard, perform the following steps:

  1. Open the storyboard for Sales Overview by clicking on the thumbnail.
  2. The right-side pane of the storyboard represents six libraries that serve as the...

Adding embedded sheets to the story


Multiple sheets can be added to the story and the following section deals with the steps involved.

Getting ready

As in the previous recipe, we will again make use of the Automotive.qvf Qlik Sense application:

  1. Open the Automotive.qvf application from the Qlik Sense hub.
  2. Next, open the Sales Overview story, which was created in the previous recipe, by clicking
    on the toolbar.

How to do it…

Please follow the steps for adding embedded sheets to the story:

  1. In the story view, click on the
    icon in the bottom-left corner of the storyboard to add a new slide.
  2. On the panel at the right, click on
     to insert a sheet.
  3. Select the In-use overview sheet from the dialog box, and set the alignment on the slide (left, center, right), as shown in the following screenshot:

 

  1. Click on the In-Use overview button to select another sheet for the slide.
  2. Save the file by clicking on the
     button.

The story can be played as a presentation by clicking on the 

 button on the left-hand side vertical...

Highlighting the performance measure in a bar chart


One of the essential components of a Qlik Sense dashboard is the Key Performance Indicators (KPIs). The KPIs indicate the health of the company based on specific measures. The information displayed in the KPI should stand out distinctly and demand attention. For example, one of the key KPIs that a CEO of the company may like to have on his dashboard is Actuals vs Budget. A CEO is mostly interested in knowing whether the company is below or above the budgeted figures. So, it makes sense to highlight the required information inside the visualization object. The following recipe explains and shows you how to do this in a bar chart.

Getting ready

A "Dial Gauge" is quite commonly used to display the key KPIs in Qlik Sense. However, the best design practices say that the "bar chart" is the most effective way of conveying the information to the user. The following example makes use of a bar chart to strengthen this thought.

Perform the following...

Associating persistent colors to field values using the script


The best practices say that a designer should avoid using bar charts with multi-colored bars or avoid having too many colors in any of your chart objects. But, at times, we need to cater to the demands of the organization and take an uncalled for approach to designing. The following recipe explains how to associate a distinct field value with different colors in the Qlik Sense script.

Getting ready

This recipe serves as a good example to demonstrate the use of the pick function in the script. Perform the following steps to get started:

  1. Create a new Qlik Sense application and name it Persistent Colors.
  2. Open the Data load editor.
  3. Load the following script that contains information about the actuals and budget of four products. The script is available for download on the Packt Publishing website:
ProductsTemp:
LOAD * INLINE [
Product, Actuals, Budget
Footwear, 100000, 120000
Tyres, 180000, 150000
Mountain Bikes, 250000, 195000
Road Bikes...
Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Explore newly added features in Qlik Sense
  • Discover best practices to work with data using Qlik Sense
  • Learn to implement advanced functions for better data insight

Description

Qlik Sense allows you to explore simple and complex data to reveal hidden insight and data relationships that help you make quality decisions for overall productivity. An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. Qlik Sense Cookbook is an excellent guide for all aspiring Qlik Sense developers and will empower you to create featured desktop applications to obtain daily insights at work. This book takes you through the basics and advanced functions of Qlik Sense February 2018 release. You’ll start with a quick refresher on obtaining data from data files and databases, and move on to some more refined features including visualization, and scripting, as well as managing apps and user interfaces. You will then understand how to work with advanced functions like set analysis and set expressions. As you make your way through this book, you will uncover newly added features in Qlik Sense such as new visualizations, label expressions and colors for dimension and measures. By the end of this book, you will have explored various visualization extensions to create your own interactive dashboard with the required tips and tricks. This will help you overcome challenging situations while developing your applications in Qlik Sense.

Who is this book for?

Qlik Sense Cookbook is for data and BI analysts who want to become well versed with Qlik Sense to apply business intelligence in data. If you are a beginner in data analytics and want to adopt an independent recipe-based approach to learn the required concepts and services in detail, this book is ideal! Individuals with prior knowledge of its sister product, QlikView, will also benefit from this book. Familiarity with the basics of business intelligence is a prerequisite.

What you will learn

  • Source, preview, and distribute your data through interactive dashboards
  • Explore and work with the latest visualization functions
  • Learn how to write and use script subroutines
  • Make your UI advanced and intuitive with custom objects and indicators
  • Use visualization extensions for your Qlik Sense dashboard
  • Work with Aggr and learn to use it within set analysis

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Aug 30, 2018
Length: 334 pages
Edition : 2nd
Language : English
ISBN-13 : 9781788997171
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 : Aug 30, 2018
Length: 334 pages
Edition : 2nd
Language : English
ISBN-13 : 9781788997171
Vendor :
Qlik
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.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
$199.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 zł20 each
Feature tick icon Exclusive print discounts
$279.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 zł20 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 823.97
Mastering Qlik Sense
zł221.99
Qlik Sense Cookbook
zł197.99
Qlik Sense: Advanced Data Visualization for Your Organization
zł403.99
Total 823.97 Stars icon
Banner background image

Table of Contents

10 Chapters
Getting Started with the Data Chevron down icon Chevron up icon
Visualizations Chevron down icon Chevron up icon
Scripting Chevron down icon Chevron up icon
Managing Apps and the User Interface Chevron down icon Chevron up icon
Useful Functions Chevron down icon Chevron up icon
Set Analysis Chevron down icon Chevron up icon
Using Extensions in Qlik Sense Chevron down icon Chevron up icon
Advanced Aggregation with AGGR Chevron down icon Chevron up icon
Tips and Tricks Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.3
(6 Ratings)
5 star 50%
4 star 0%
3 star 16.7%
2 star 0%
1 star 33.3%
Filter icon Filter
Top Reviews

Filter reviews by




pr2020 Jan 16, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great product and services, Thank you!
Amazon Verified review Amazon
Josep Navarro Feb 04, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Estructura a modo de recetas es muy . Ideal si ya tienes ciertos conocimientos básicos, no tanto si se busca una introducción inicial general.
Amazon Verified review Amazon
Anwar Shaik Dec 20, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Ok
Amazon Verified review Amazon
Kez Jan 23, 2019
Full star icon Full star icon Full star icon Empty star icon Empty star icon 3
Personally I don't appreciate the cooking terminology and I find the running of subjects one into another a bit difficult to follow, I have been trying to read the whole book so I can try to figure out how to use the concepts for my business - which is not financial so I am forever translating date offset functions for accounts into what I need. There are lots of places they could have put more information or background but kept it content light. Good amount of programming if you need that tho.
Amazon Verified review Amazon
Larry G Whitfield Aug 31, 2023
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
The pictures is very blur. Can’t read at all
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.