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
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
Free Trial
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.3 (6 Ratings)
Paperback Aug 2018 334 pages 2nd Edition
eBook
NZ$39.99 NZ$57.99
Paperback
NZ$71.99
Subscription
Free Trial
Arrow left icon
Profile Icon Labbe Profile Icon Hand Profile Icon Kharpate
Arrow right icon
Free Trial
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.3 (6 Ratings)
Paperback Aug 2018 334 pages 2nd Edition
eBook
NZ$39.99 NZ$57.99
Paperback
NZ$71.99
Subscription
Free Trial
eBook
NZ$39.99 NZ$57.99
Paperback
NZ$71.99
Subscription
Free Trial

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

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 : 9781788997058
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 : Aug 30, 2018
Length: 334 pages
Edition : 2nd
Language : English
ISBN-13 : 9781788997058
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 NZ$7 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 NZ$7 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total NZ$ 299.97
Mastering Qlik Sense
NZ$80.99
Qlik Sense Cookbook
NZ$71.99
Qlik Sense: Advanced Data Visualization for Your Organization
NZ$146.99
Total NZ$ 299.97 Stars icon

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

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.